Tough topic. I got myself a Fender Jag-Stang in the 90's, when I was a teenager, and heavily into Nirvana. It was up for grabs below street price, and I didn't care about the cringe-factor at all. Sold it in 2005, which I sometimes regret - but only because the old ones go for good money these days...
About ten years ago, I kept lusting for a P90/Bigsby hollowbody, so I researched the options, only to find that a used Yamaha SA503 would give me exactly that, at an affordable rate. Three pickups, any combination possible, etc.
Since I'm a QOTSA nerd, it would've been a huge no-go. After contemplating various aspects and lots of overthinking, I still went and bought one (800€), and it's a nice guitar!
It's not like it has the band's logo on there, or a printed signature on the headstock, so it's not as obvious, especially if you're not aware of that particular model. Sounds and plays nice, although unfortunately the wiring and pots kinda live up to the "cheap/vintage" vibes they're going for.
Looking fwd to posting a pic, but I should probably do some cleaning before that, maybe even restring.