Interestingly, I find I have tended to play humans in most of my previous D&D experiences (yes, even in 2e when being human "gimped" you unless you wanted to play a Paladin). Maybe part of that was a reaction to the often witnessed min-maxing that accompained some players' race selection.
I've played just about every race at one point or another, however. I've played a dwarf fighter in 2e, which was fun thanks to whichever "Kit" it was that I was using for the character.
I've played an elf ranger who was lots of fun and responsible for why Ranger became my favorite class in 2e (but not so much 3e).
I've played a couple of halfling characters (mostly Thieves in 2e) that were fun.
Then there's Cev, the only gnome character that I've actually played. Very cool.
I built a concept for a half-orc psion before that I thought would be fun to play, but I never did use him.
I agree with Engar, the Dark Sun races were probably the most inspiring non-humans that I've encountered. The Dark Sun halflings and elves were really cool and thri-kreen as a "core" race was a neat option. Half-giants were definately one of my favorites as they were just so quirky and could make a great excuse for comic relief (which every adventure needs from time to time).
HARRY DRESDEN — WIZARD
Lost items found. Paranormal Investigations.
Consulting. Advice. Reasonable Rates.
No Love Potions, Endless Purses, or Other Entertainment.