Bev and Deanna had sweet personalities. Doctor Crusher's empathy for her patients, especially, her bedside manner. And though I do not prefer aggressive women, I find Ro and Yar to be the hottest babes onboard. Having said all of that, I never did have a crush on any of these women. I love these characters, I think the actresses are all beautiful, but yeah ... just never crushed on any of these, really.

I can't really see any of TNG men being a good match for me.
Data with an emotion chip is probably the best option. He's smart and funny, handsome, and would write a program for himself to be a good partner.
Riker doesn't seem like he'd ever settle down, although he is very handsome.
Geordie is sweet but too dull. Picard is very sexy and all, but too old for me. Wesley is too young and annoying.

Oh it was definitely Deanna. I was particularly struck by her beauty when they went to the big screen (GENS and FC), which just happened to coincide with the onset of puberty.

My first actual screen crush though was Olivia Newton John as Sandy in Grease (not the 'slutty' Sandy from the end of the movie either, but the regular homely one we see through most of the movie's run time).

Never had a true crush on any of the female TNG regulars (though I did crush on Jadzia Dax and Seven Of Nine), but if I had to choose one I'd go with Troi. Both Deanna and Beverly were pretty hot, but Deanna's personality is more of a match for me.

I'm a little older than Gates McFadden and I thought she was radiant. She was on the faculty of Chapman University in Orange, CA when our daughter went there and I was so tempted to hang outside her classroom so I could meet her but I didn't want to frighten her in any way so I never acted on the impulse. Probably a good decision.