Have you ever turned down your dream date?

I whinged on another thread about this. A foreigner was in my city for a couple of weeks and asked me out on bumble. He was cute and most definitely my type, he seemed so nice, and it was just a coffee. I thought it would be a lovely date with a lovely man and an experience worth having.

He turned up and his personality was exactly my type and the chemistry was through the roof. His values matched mine too. He asked if we could keep it going when he moved away and I said no, because we're 2 dates in and hadn't formed a solid connection for long distance and I couldn't put in a half-effort into anything. I stand by that, I had fallen too hard in a short time and I couldn't handle that. Even though I'm moving to his country in about 6-8 months.

Has anyone every done this before and found someone else? I feel like I lost my chance, however still knowing if I said yes that a LDR wouldn't meet my needs and I'd go crazy. He's really crap at remembering to message back.