It wasn't the name alone that did it, but I got the Newbury Comics pressings of Phanerozoic I and Phanerozoic II (by The Ocean) on vinyl because A) the name is cool, and B) the pressings looked cool. Turns out the albums sound cool too.
I gave The Crazy World of Arthur Brown a try because of the album artwork. Turns out it's now one of my favorite albums.
I'd heard Ziltoid the Omniscient was good, but what really won me over was the album artwork. Between the cheesy name and cheesy artwork, I had to give it a listen. It's easily one of the greatest albums of all time.
King Gizzard and the Lizard Wizard.
I've been considering getting one of Intel's Raptor Lake cpus.
Uh, I'm trying to think if there's anything else. There have been games that have caught my eye purely because of the name, but none of them were that great iirc. I think Risk of Rain mighta been one of them, and that one was pretty good; but most of the games I've tried based on name alone were pretty meh from what I remember.