I loved Dark Rift for the N64 when I was a kid. I never even knew that people hated the game until I got the internet and read reviews about it years after I played the game.
Also one of my favorite survival horror games of all time is Siren for the PS2. The game didn't get a lot of good reviews and it's a very hard and confusing game that most people can't complete the first time without a strategy guide, but I loved it because it was genuinely scary and had a very dark and gritty plot with some very interesting characters.