When I first met my wife she had a standard queen Sleep Number. Took me a while to get used to the ridge in the middle but eventually it was fine and once I found my Sleep Number never slept better.
After we bought a new house this summer with a much larger bedroom we also bought an adjustable split king Sleep Number with all the options you can think of and a pricetag to match. For sleeping we absolutely love it as there is no way we would be able to come to a decision on the firmness of a standard bed. The foot warming is amazing, it allows you to keep the house cooler while sleeping or just warm up the bed before climbing in. The adjustment of the head and foot is awesome for reading.
A few issues we have ran into, if you’re a couple that needs to snuggle, the split bed certainly makes it more difficult, the center ridge is big especially with the lower sleep numbers. Also if you have a medium to large dog that sleeps between you and your wife the crack between the mattress may slowly start getting wedged apart from the animal. Our dog gradually steals the covers overnight by stuffing them down the crack to keep himself on top. And finally the smart phone apps to control the bed can occasionally be buggy, enough so that you can’t make any changes to the bed, but eventually fix themselves.
Also make sure your bed will get a good wifi signal.