I've ended up deciding that when you get that excited, romantic rush of fancying and dazzling starlight etc etc etc, it's because you are drawn to someone you're going to get something important from. But be careful: that "something" might be a painful life lesson.
After a lot of trial and error, and after many years alone, I finally got lucky with my now-DH. That was a very different feeling: one of complete safety. With him I suddenly felt totally relaxed, uninhibited, uncensored, seen, appreciated, understood, protected, supported, in ways that I had not encountered before (even with close friends).
Do I regret the crazy shit I put myself through for years before meeting him? No, because without those relationships I wouldn't have learned the painful life lessons that eventually "qualified" me to be with someone on DH's level.
I don't think we can cheat in life by magically learning to spot the "right" things and make the "right" choices. We just have to participate and learn, and some of it is not much fun, but the tough experiences are the ones we most learn from.