there have been precious few games that have made me go "okay i need to put the controller down now" and Silent hill 2 is one of them, the only other ones that i can think of right now are "to the moon" and "spec ops: the line". Personally i consider SH2 and 3 to be excellent companions to each other,
SH2 focuses highly on the quiet and psychological kind of horror that i love, it's a very demure game, the otherworld isn't "dirty" it's very drab, subdued, subtle and sterile.
SH3 on the other hand is a bit more in your face, everything is disgustingly filthy and loud and the "industrial" aesthetic is turned up to 11.
if anything SH3 has to be commended for it's for giving the main character a personality though. Heather is much more appealing as a main character than James Sunderland