Bad dating experience...kinda long

Arielle
I met a guy at my job during the short time my bf and I were broken up. Really sexy, really funny, instant chemistry. I work at a hotel and checked him in, he kept coming to the front desk to talk to me and ended up giving me his number. He's from NorCal and he was in SoCal on business.
We texted and snap chatted every day for about a month and a half. He was coming back to SoCal on another business trip and we planned on going out. We were both pretty adamant about wanting to hook up, however he implied he was not just looking for a one night stand. I went into this open minded. The guy kept saying things like he wanted me to visit him in the future and making other plans with me. He got personal with me, and I did the same.
He finally got here and had a hotel booked for two nights. Our first night out was so much fun, and our night in was amazing, we were up until 4 am. Then things got weird. The next morning he told me his cousin had been shot and was in the hospital. But he said he didn't want it to ruin our time together. Then after I got out of the shower he told me he had to take a call and left the room. When he came back he said he had to take a flight back home that night because there was a family emergency and he had to pick up his daughter. He still wanted to spend the day together and we really enjoyed each other's company. I wasn't sure what to think about the whole thing.
During our conversations he said things like, "I'm not a one night stand kind of guy", "I'm crushing on you hard", kept talking about seeing each other again and that he would miss me and hoped I wouldn't forget him after his visit. When he finally left he told me it was going to be a busy weekend and I wouldn't be hearing from him as much but he would let me know when he got back home that night.
He did text me once he landed. And that was the last time I heard from him. Part of me wasn't surprised. What bothers me is why not be straight up about what this was? I never said or implied that I was looking for anything more then a hookup, however why lead me on and say all of those things when you already got the cookie? Why be so sweet and act so interested in me if you're just looking for a hookup? This is a grown man with a daughter that he adores, I just don't understand using a woman like that when you should know better to treat women with dignity and respect. Honesty is all I wanted and now I just look back and feel used and played like a fool. Has anyone else had anything like that happen to them? I guess it's the risk you take when you hook up with someone right away.