"I want a great catch and for some reason the ones that I think that are obviously are not but I'm so blinded that I still end up liking them."
This guy behaved very badly. VERY badly. He had been definitely informed way beforehand that you were in town, sends you a text in the dead of night claiming to "hear you were in town," and not finding his car sounds kind of lame.
You say that the guys you think are great catches are obviously not, but you still like them.
I don't want to make a snap judgment here, but mammelah, your self-esteem needs a boost.
A great catch treats everyone with respect and consideration. A great catch is not the one who treats a girl like an afterthought. Anyone who behaves so badly on a date, when he is supposed to be sitting up straight and acting his best, is probably worse when he is on his own turf.
You do not want to be a doormat. You want to be cherished. Any man who pretends not to know that you were in town and makes no advance preparations for a date should not be liked. At all.
It is very possible not to like "that way" every nice guy you go out with, but if you only like the ones who treat you badly, that is a problem.
All of us are a bundle of good and bad qualities. ALL of us. But how he behaved isn't even about that. He had no manners. None. He is supposed to treat every girl he goes out with with respect and consideration, and he didn't.
If you consider yourself to be a mannerly young lady, you have a right to expect manners in your date. That most for starters.