I had the old Xbox 360 version of AitD. ( Due to the low review ratings I was actually able to pick up the collector's edition really cheap, with a bunch of extra goodies. ) Aside from being a little rough around the edges, I don't remember any major problems, but I don't know how bad the PC port turned out.
As for FEAR, I only played a few hours of the first one but wasn't really impressed. I should add that I have about zero interest in generic military Shooters, and for the most that's what FEAR felt like during those first few hours. You just shoot at human opponents in SWAT gear, and every now and then there's some random scripted shock effect or vision and most of those were rather boring. I do remember a handful of more creative and creepy effects later on, so maybe the game gets better after the first few chapters/missions?
Bookwyrm627: You mentioned some console games, so maybe take a look at Siren (PS2) if you can find it. It has some rough edges, but I had trouble sleeping after I tried it out.
The story is broken up into segments that you unlock, so you don't get a linear picture at first. It has a neat mechanic in that you can look through the eyes of the monsters; you basically expose yourself to their mumbling and snarling while you watch to learn their locations, patrol paths, armament, etc. Some parts give you a weapon, some don't. Sadly, there are a few areas where you need to escort someone, though you do have some basic commands.
Also, it doesn't look like anyone has mentioned Fatal Frame yet.
I've played some of the Forbidden Siren and Fatal Frame/ Project Zero games on PS2 and 3. I really enjoyed the first Fatal Frame. It's a refreshingly different setting and gameplay compared to most Horror games. Too bad that most of those games aren't available on PC, aside from emulation.