@devinebass did a great podcast episode about this very topic which I listened to in the car the other day.
https://scottsbasslessons.com/podcast/g.a.s-its-a-thing-with-scott-ian
What's interesting is to hear how tastes/fashions have changed over our lifetimes, from six string active basses with fancy tops to five strings with a high C, then back to the P bass. Scott talks about how he made the conscious choice to switch to a p bass for his channel to differentiate himself from those big name virtuoso players using high end 5ers at the time. He didn't even especially like the P bass sound, but has grown to love it - and players like Pino switching to a P bass arguably caused a raft of players to follow suit, or at least make that change at the same time no doubt encouraged by the sort of music they're being asked to play.
Personally, my journey went from 60s jazz bass twang to active carbon fibre and synthesiser then stripped back to the P, 70s J and finally Stingray. I've mentioned it before but for the the Stingray has elements of each bass that I fond both comfortable to play but with the top end on tap, tight bottom end and an unmistakable character in a mix.
Like Ian says on the podcast, and especially in the episode after the one above, I like to have 'my' bass, and then have others that make me mould to the way they want to be played, so that I sound different and they bring out different things in my 'playing'
Sometimes I just wake up and need to play a P with flats. Other times I'll reach for a top 70s jazz and slice my head off with the sheer hifi top end. My '83 Ray though has a great even attack with a really plastic sounding middle range which seems to work on everything. Every day is an adventure.