I like the quote "If you're excited about an investment, it's probably a bad idea."
Here's how I tackle this problem. Everytime when I have an exciting investment idea, I'll try to explain it to my wife, who has no experience or interest in investing. She is also super suspicious about things she doesn't understand.
If I could make my wife understand this idea and get a "Sure, I don't mind" from her, that's usually a very good sign. It shows that I totally understand what I'm about to do and the logic behind it is solid.
Otherwise, I'll just move on. That's how I avoid touching any metaverse game, meme coin, or BNPL stocks.