if you don't mind a little horror, Post Mortem is really good. There's some gore but the game isn't focused on it. It's a really good detective story.

there is also Ripper

^
As far as i know, Post Mortem not using first person view.

For dialoges it uses a third person view, but the main action (movement, item search, etc) is first person.
http://www.youtube.com/watch?v=yVeX3yMfKXg

Hell, yeah. It's the horror that only hints at gore. It shows you ordinary things like sheets, and gives you lectures about lobotomies and shock therapy. It lets you talk to polite ghosts and even play games with them. It even tries to kill you a few times, but the solution is always there.

You're right. It looks like i'm getting older. I used to play that game but it seems i mixed it with Still Life (which supposed to be the sequel?),

There are many dialoges and cutscenes in Post Mortem, very likely you remember them more then the movement. Still Life is the sequel, but not very hard connected to Post Mortem.

I'd actually recommend some of the Nancy Drew games, if you're not too manly to play them

Lost Eden

You should check out
Return to Mysterious Island 2 - Mina's Fate
Destination Treasure Island

And the other Kheops Studio games.

Personally, I think the Zork series has some classics. Although the first games of the series were text adventures, the series eventually moved into first person graphic adventures. I recommend trying the text adventures first to get the feel of Zork, then move into these:
Return to Zork- Quirky characters, often hilarious situations and compelling mysteries abound at every corner. This one will thrill you, make you laugh, and at times make you cry (be warned-some of the music is very depressing) and even scare you at times.

Zork Nemesis AKA Zyst Grimesis-This one's like a very grim version of Myst with a serious attitude. The adventure is full of challenging puzzles, but it is the darkest and most GRUEsome (pun completely intended) Zork game ever made. If you have children nearby, don't play this one as it is very graphic at times. But if you don't mind stark horror imagery and a really dark storyline, give this one a try.

Zork Grand Inqusitor- Zork fans never really wanted a dark, grim, depressing adventure in the Zork series, and many felt betrayed by Nemesis. Activision apologized with this final Zork adventure that not only had some humor but became a straightforward slapstick comedy adventure that will often have you laughing so hard you need to stop for a few minutes until your sides stop hurting. As a counterbalance to the mood killing Nemesis, this wild slapstick-filled laugh fest of an adventure has plenty of good puzzles and many good jokes. Really the final two Zorks are two sides of a coin-the somber,dark side of Nemesis and the wacky slapstick side of the coin being Grand Inquisitor.

If you like first person adventures, you owe it to yourself to try the Zork games.

As much as i enjoy the brutal, stressful, heavy horror in games like Amnesia there's alot to be said about subtle mind horror, the one where you are not shown much of anything and instead they give you the 'tools' to create your own horror inside your mind. I think this game managed to do that incredibly well, the outcome being a very clever and refined horror, the kind of horror that lingers in your mind long after you've finished the game.

It's good to know i'm not the only one who enjoyed this one ;)

What about the 7th guest or the 11th hour

Outcry (2008) is another of these mystery/horror adventures with point and click mechanics (in the vein of Darkfall, Scratches etc.). Can't say if it's good though, I didn't manage to install the retail version on my computer (probably due to its DRM, but that's another topic).

EDIT: A DRM-free version is currently on sale at GamersGate (65% off). They also offer a demo on the page.

thats more puzzle then adventure. but still good games nevertheless.
might add 9 too then.