Of course I appreciate a good-looking guy or girl...but I'm usually attracted to someone's mind much, much more than the physical. I've had some guys, great-looking but boring/stupid as hell, and I wouldn't even consider fucking em. Yet another man, my one true love, was your "dirty hippie" type, not your conventional good-looking guy...but to me, hell, he was the hottest thing on the planet. For real. If you love somebody or have a connection mentally, I think that will drastically raise their level of physical attractiveness in your eyes. Beauty is in the eye of the beholder, right?
In a setting like a bar, though, I'd want to talk to the guy I find physically attractive. You can see that from across a room, whereas finding out if someone has an awesome personality is something that takes time to discover. If a guy approaches me and asks for my number, I'm likely to give it if I find him physically attractive. Now, if there's a guy who isn't "good-looking" but I've had a chance to make a connection, have a conversation and find that he is interesting and cool, then I'd give him my number. The lesson I guess? If you're not the best looking guy, but you have a great personality, let it shine cuz there are plenty of women who will still be interested based on that!