Even if they support multiple SSIDs, you probably want to use a single SSID on your device. Realistically speaking, your device should detect that the signal strength is low and connect to a better Eero if available. Sticky clients are plenty though, enterprise APs generally handle this by monitoring client signal strength and forcefully kicking out sticky clients to force them to move to better access points.
Not sure if Eero does this.