Nobody likes showing off my basses more than me. They're not super special or anything, but I used to be in love with the idea of switching basses just to show off the collection a little, plus it's cool to have different basses for different sounds and tunings. I've tried to enjoy it, especially since I spent a good many years doubling on upright on most of my gigs. Sounded like a good idea at the time.
Here's why I ended up hating it...
---It either slows the show down or it leaves you hanging and looking like amateur night because you're not ready when they start the next song. And many bandleaders don't care if you're switching and they'll count the song off anyway. So I just want to play one bass that can do it all.
---It's easy to switch basses that all have similar sound and output, but switching between a Stingray with new rounds and a Hofner with old flats is going to take some EQ to keep levels consistent and tones not so different that it throws the mix into a meltdown. And the more different basses, the more EQ's you need. Some folks will use programmable EQ's or pres and that's what I did most of the time, but it can take some effort to get it right. And I just don't want to spend time screwing with it. Once saw Heart's sound tech have to rebuild the bass mix from scratch for every other song because Steve Fossen switched every other song and never used the same bass twice.
---Two basses are manageable, but any more than that gets on my nerves during setups and teardowns. Have I done it? Sure I have! How do you think I know???
Anyway, thx for listening to me yak while I try to get over health problems. Been a while I had this much free time since going corporate. And feel free to comment either pro or con.
Amen. Totally with you, for the reasons you mentioned.
I have a modest collection of 10 basses. I consider each one a "primary" (if not, I wouldn't own it). For gigs, I bring two and only two basses: primary, and.... "backup primary".

97% of the time I only play the "primary primary"!
#1 exception: I played a few sub gigs with a band that played half their songs in standard tuning, the rest of 'em detuned a half step. So, I brought one in each tuning. I play five string and can transpose, but they were sub gigs, so why make 'em more difficult than necessary? I switched basses when they switched guitars.
#2 exceptions: in the decades I've been gigging, I've had a half-dozen-or-so mid-song failures. Usually a broken string, but I also had an onboard preamp go wonky, and then there was the time that the nut broke on a brand new bass, and the E string went flopping off the side of the neck. So: backup time.
The rest of the time: once in a blue moon I'll play the second bass gratuitously -- switching is
always done on break. Then there are the times I'm gigging a nearly-minty-fresh bass, and a friend sits in on bass, so I'll hand him the black Sadowsky in my avatar -- that one's already got a lot of road rash!