Most Helpful Guy
I think it's flattering, no matter what.
I'd probably feel somewhat anxious too. It's not a question of me being either pleased or weirded out. My mind would be more focused on how to respond, and I'd process everything later. I think ultimately I'd be happy that the cat was out of the bag. I want to know, though I may not always know how to respond if I'm caught off-guard.
It feels more awkward to me if I suspect someone likes me, but they won't say.