Did you somehow miss Resident Evil 4? I mean, okay, the Gamecube wasn't the most popular console in the world, but it was ported to the PS2, which everyone had five of. And later to the Wii, which everyone had five more of.
And then there was the recent Resident Evil 4 HD release for Xbox 360 and PS3, which I'm basically going to echo: Resident Evil 4 is still great, still a milestone in the medium. Maybe your mom never let you play it or you've only owned a Dreamcast, PC, and Game Boy Pocket for the last decade.
Whether you want to atone or revisit it, Resident Evil 4 on Steam is a great destination.