I have that experience. Like every other experience the novelty wears off and I find myself keeping the vibe to a room because it’s distracting; lizard brain stays connected to music and I forget why I went across the house.
In the end I use it so sparingly (social gatherings) owners of detached homes without shared walls, could save the money and time and just turn up the volume.
When I bought my house 13 years ago I asked the electrician to run speaker cable from the living room into the adjoining kitchen. I wired up two pairs of extremely competent car speakers in series (because 4ohms) in the kitchen ceiling, one over each corner of the dining table. I have two amps in the living room, one is an ancient 5.1ch Yamaha that runs a very decent set of speakers and sub, and a nice little Denon stereo amp that's hooked into the kitchen speakers. A single 7.1ch usb sound card runs both, and that's connected to a MeLe Quieter (tiny little N100 device attached to my TV). The entire setup is dirty cheap and let's me fill the downstairs of my home with glorious music, and it never fails. I can swap out any of the bits easily (in fact I replaced my main floorstanders with a lovely pair of DALI a year ago). I've never wanted to extend that upstairs. In the bedrooms, some really nice Edifier Bluetooth speakers are more than adequate, and in our offices we mainly use headphones (in my case I still use my old wired Senheisser HD700 because they're the most comfortable things ever)
I love my tech stuff, and I've got home assistant doing the lights, but it never once crossed my mind to mess with the sound system, except for occasional hifi upgrades. Eg next up: run a subwoofer cable from the stereo amp to the kitchen, but I'm in no rush.
I have the same experience - my home runs seven Logitech (formerly Slim Devices) “squeezebox” players from a home server with a ripped collection and options for Spotify. The networked players either have their own speaker, or are connected to amp/speakers. In practice almost all of our music plays through these devices. It’s great.
The only time we connect multiple players to sync up is at larger parties, like once a year. It’s just one button press to do it, so not using this capability isn’t that it’s too complex, it just turns out not to be that useful to us.
The main use case for multi zone audio is handled by the A/B/A+B speaker setting on one particular amp.
In the end I use it so sparingly (social gatherings) owners of detached homes without shared walls, could save the money and time and just turn up the volume.
That said, as always, YMMV