I joined Gamefly this week. $14/month to have 1 game out at a time, but they've got pretty much whatever you're looking for. I have the Metal Gear coming Monday. I just have to pry myself away from Halo 2 first.
Heard good things about RE4 and, when I had my Cube, I loved me some Metroid and Viewtiful Joe.