I can't abide flat wound strings either. But it's got to be a matter of taste.
I use Rotosound Swing Bass 45-105s or Elite* roundwounds (same gauge), with double ball ends for the Hohner Jazz bass. This is because I want to have a really bright but deep sound. In years of gigging a few times a week I can honestly say that I only ever changed a set of strings after either one of them broke or if the sound became dull - both of which events were rare. I might change them if I was doing some recording, but generally it was not necessary. I haven't played in anger for 10 years now and still have the same sets of strings on both basses that I had when I was last on stage. They still sound and look bright - but I do give them a good rub down with a decent duster or lint free cloth at the end of every playing session and South West France is mostly warm and dry
Six string guitars, on the other hand . . . many changes of strings, and at least once every six months. They just don't last. I've never really settled on a brand for them, just the gauge - 09s.
*Looks like your hero Norman Watt-Roy uses Elites