I love all of the games, and 2 is probably the better one, but I want to give 3 some attention, you really should play it as well. (well, preferably after the first 2, there are some connections in the story that are more impactful knowing the previous characters)
The third game is longer, it has a different structure (you have a safe space/hub in your home, and you go to the usual haunted mansion scenario after you sleep) and it uses that to great effect. I love the contrast horror games can create by having a safe place, and the concept of your nightmares starting to affect the character in the real world is great. This fact also gives more variety in how the story goes, and it can be very interesting to see what happens in the normal world, I will leave it at that.
The story is also pretty good, handling some serious themes very well and having a genuinely emotional ending. The story also uses different characters, and the mansion is a little different for each one, which I thought was pretty cool. It's all in all a different experience from 1 and 2, and all the better for it;
It's honestly one of my favorite games, give it a shot!