It won't "take it to the limit", but I do recommend Knights of the Old Republic for seriously awesome 3-person party action. In the realm of somewhat recent games with decent graphics, Arx Fatalis is pretty solid too, and very much a traditional roleplaying game with "levels" and point allocation and all that.
For an FPS with some fairly strong RPG elements, there's Tron 2.0.
Posts
For an FPS with some fairly strong RPG elements, there's Tron 2.0.