my two cents, I think that this is all "sociological", and it depends on the music related to the "age".
in the 50's/60's the bass soundend "big" and "round", and that's what the "music" wanted and what was produces in terms of basses: big "neck" pickups, short scales, hollow bodies... everyone used to play near the neck (think about John Paul Jones, whose thumb was "on" the neck).
with the arrival of rounds, and bass players using them, slowly the bass sound changed, players moved their fingers near the bridge, and then there was Jaco, and the "nasal" and "guttural" sound became a standard, so the music industry "wanted" that sound.
in the 80's the "vintage" sound was hard to find, lots of players started using extremely light gauges (Mark King, Nick Beggs, Pino Palladino?). the "big vintage sound" could be heard only on blues records, or from "old" or "vintage sounding" artists, like Dire Straits or Paul Simonon, to mention just two.
I guess the 90's saw the comeback of flats, with a reemergence of a 70's vibe both in rock and pop music, with less electronics.
now you can hear everything without discrimination, and depending on what's needed in the specific situation.
______
flats have their specifc sound and vibe: the shorter sustain is useful in many recording situation, and the "fundamental oriented" tone is perfect for a bassline that needs to sit in it's right place in the mix.
obviously if you want to slap like Miller or sound like a chainsaw, they are note the right choice...
personally I'm a flatwound user, I don't like the scooped or metallic sounds, and I don't play in situations that needs that.
how could a track like this one sound good with a "clangy" sound?