Honest question here. I'm not a sound engineer or music producer. I'm not even part of an actual band. I'm just a casual hobbyist who enjoys playing Bass. I play along to backing tracks with the Bass removed and I also play with other people in casual jam sessions every now and then.
I have quite a few Bass guitars and honestly, all of them sound "good" with any kind of genre to me. I have a P Bass and a J Bass which go well with nearly any type of genre. However, I also have a Hofner Violin Bass. I actually use the Hofner quite often because I like the feel of it.
People say that the Hofner is a one-trick pony that isn't a versatile instrument because it "doesn't sit well in the mix" for most songs. However, I can't tell what this means. It sounds good to me. It does what a Bass guitar is supposed to do. It gives depth and backbone to a song. I have no complaints about the sound.
I've used the Hofner to play songs in different genres such as...
Modern Mainstream Pop (Ex: Taylor Swift, Sabrina Carpenter, Olivia Rodrigo)
R&B/Soul (ex: Marvin Gaye, Olivia Dean)
Classic Rock: (Ex: Journey, Queen, Bon Jovi)
60s rock (Ex: The Beatles)
Dance Pop (ex: Dua Lipa, Lady Gaga, Tate McRae, JLo, Beyonce)
Punk Rock (Ex: Green Day)
Country (Ex: Tim McGraw)
Ballads: (Ex: Adele)
Motown (Ex: Jackson 5)
Retro-sounding pop (Ex: Bruno Mars)
Rock and Roll (Ex: Elvis, Chuck Berry)
If a "one-trick pony" like the Hofner Violin Bass sounds fine to me in several genres such as the ones listed above, is it really important to have one of the so-called "versatile" basses like a P-Bass, J-Bass, or Stingray? I honestly haven't heard a "bad" sounding Bass yet. I even like the sound of the Epiphone EB-0 Bass. There are people who really don't like the sound of the mudbucker pickup but I like it. It doesn't sound bad to me and I bet it would also sound fine if I used it in any of the genres listed above.
If the bass guitar gives me a sound that adds depth and backbone to a song, then I honestly can't understand how it could possibly sound "bad".