Bioshock might not be an RPG by definition, but I thought it did a great job of immersing you in a role.