I'm 21, but I was still struggling to play the Resi 1 ReMake on the old 'cube when I was 16. I'v gotten better at it in the last few years, but I find that I'm very much driven by the story told in horror games, and the mystery involved, even if I get freaked out every now and again.
I also think that the adrenaline rush you gain from horror games is what drives some people on. Horror games are probably even more adrenaline pumping than most FPS games, atleast they are for me. A game such as FEAR really got my heart going, even though it was just the demo, at half three in the morning in a box room, on my own. Freaked me out, almost transforming me into a quivering wreck...but my heart was pounding like crazy. So I played it again, and again. Adrenaline is addictive.
With the rollercoasters, I don't think it's so much fear driven. You don't go back to things because you are scared of them (unless you are trying to rid yourself of the fear), you go back for the thrill of the ride. Same with the horror genre. If you played a game that instilled no emotion in you at all, you wouldn't go back to it. Atleast, I wouldn't.
What makes a good horror game? Hmmmmm...
I'm going to have to make reference to Resident Evil 5 here. Here is a game that is undoubtedly good and although the first though that comes to mind when someone mentions 'Resi'is horror, I just don't get that feeling in it. Why? There is no feeling of alienation, loneliness or dread. You are a big, muscley man who has a dislike for huge boulders and constanly has someone tagging along with you. That isn't a scary thought.
I guess that also answers the 'what don't you want in a Horror game?' question. I don't want to be cuddled and have my hand held. I want to feel alone. I wan't to feel like I have no hope. A sense of immense dread to overflow me, before being throw, head first, into an epic run for your life scene, no time to shoot, JUST RUUUUUN! That is adrenaline pumping right there.
I think the 'good or bad' question is very much opinionated. What I have just described there is my idea of a good horror game. A bad horror game is one that, well, fails to instill the feeling of horror, much like Resident Evil 5.
Hope that helps
I myself have a 10,000 word project that I should be doing right now...
:[