1. Neverwinter Nights 1 & expansions
Not so much for the original campaigns but for the many, many excellent free community-made modules. I've played 126 of them, many of them giving over 30 hours of gameplay - by far the best value for money I've ever had for any game ever.
2. Diablo 2
Of course. I even wrote
spot reports about it on USENET back in the day.
3. Vampire the Masquerade Bloodlines (with community fixes)
A broken game rescued by the community. Tons of roleplay and replay value and a cool plot.
4. Bungie's Myth series (Myth III not so much)
I never liked the race to gather resources in RTS games. Here you must manage the forces you're given. Plus excellent single-player plot.
5. No One Lives Forever
I just loved the humour, snarky dialogue and 60s feel and music. NOLF2 was also good.
6. Tomb Raider (except Angel of Darkness)
The perfect 3D platformer, with guns.
7. American McGee's Alice
Love the dark twist on a classic story here.
8. Temple of Elemental Evil (with community fixes)
The only turn-by-turn D&D game that is truly faithful to the P&P game.
9. FAKK2
I just love the "let's go totally whacky" feel it has.
10. Bloodrayne
I'm always a sucker for vampire stories, plus lots of snarky dialogue and I love the tons of cool moves you can make Rayne pull off.