Pushing up to move in the direction the character is facing is entirely unintuitive in a series like Resident Evil. If the character is facing left, why should I have to press up to move? If the character is facing right, why should I have to press up to move? Camera placement makes a huge difference in how useful a control scheme is. The old Resident Evil control scheme doesn't make sense, but it was implemented out of necessity because of the PlayStation's controller. Remember, the first two Resident Evil games were released on PlayStation before Sony had introduced their new Dual Shock controllers.
If Super Mario 64 had Resident Evil's control scheme throughout the entire game and not just as a parody in the Ghost House, nobody would have bought or played it.