For those replying: please explain why you did or didn't like a game; constructive feedback is more informative than a simple "this game was awesome" or "that game was awful."
For those asking: it helps to know what sort of game aspects turn you on or off, and what you already know about the game you are interested in. It's hard to address "is [game] good?" if we aren't sure what you like and don't like, and whether or not you know the basic info about the game (genre, plot premise).
http://www.gamesas.com/index.php?/topic/1078034-unofficial-is-insert-game-here-any-good/
Useful Links:
http://www.metacritic.com/games/ <- useful insofar as you get a large sample of "professional" opinions, as well as many thoughtful and insightful user comments/ratings. Will not guarantee that you will love or hate a game you are considering purchasing/playing. Sometimes contains useful info about game problems that you can ask us here about (i.e. "I read [game] has a ton of bugs/has long loading times, are they really horribly buggy/long?").
--------------
Do any of these games svck/have hideous bugs? I know the basic premise of the game, and I think I know the genre/gameplay style, but I don't know if the game is actually any good. I like games that have a strong story/character development, and I tend to stay away from games that are mindless combat/hack-and-slash (even if they are addictive hack-and-slash).
Vampire: The Masquerade - Redemption (I have Bloodlines)
Severance: Blade of Darkness (sometimes seen without the title "Severance")
Stonekeep
Shadowcaster
Wizards & Warriors
Anachronox
Fairytale Fights
Portal Runner (PS2)
Money Python's Looney Bin
Wizardry 8
Darkened Skye
Enclave
Hellboy: Asylum Seeker (PS1)
Beyond Divinity
I of the Dragon
Scrapland, aka American McGee Presents Scrapland
Sacred Rings
Keepsake
Dream Chronicles
Rhiannon: Curse of the Four Branches
Amerzone
Blazing Dragons (PS1)
Danger Girl (PS1)
Juggernaut (PS1)
Shadow Madness (PS1)
Xena: Warrior Princess (PS1)
System Shock 2 (I get scared easily - will I pee my pants? Are there cheats?)