I personally loves the books. I refuse to let any of the hype about the movies bother me, they do not hold a candle to the books. I think they were written very well. They appeal to everything teenager IMO, and the story line was executed beautifully throughout the series.
Oh, and not to be petualnt or anything but Edward does not have any psychopathic tendencies, he is not real, he is a character and is only as he was written and was not written to have any, maybe slightly sociopathic but not psycho. You have to remember that the character is supposed to be very old and jaded to the world and has found the one thing that brings light into his life but also wants to eat it as well... Yeah, I'd be a little effed up too...
I will say though that I think Robert Pattinson is not an attractive guy, and not who I would have thought of for the role of Edward at all, Kristen stewart fits Bella though. I was expecting the other vampiers to be more beautiful than the actors they chose, but oh well. I also liked the original Jacob better than the guy playing him in movie 2.
I think they are taking all the wrong parts of the books to put in the movie, that is what makes them so crappy IMO. They focus on the romance and try to make it very tween love story when that is not how it is written.
Just my 2 cents worth.