I would have to say that the PlayStation 3 is the last "interesting" console before the two giants (who aren't named Nintendo) went with the x86 architecture. The Cell CPU was so strong in processing power that most (if not all) of the Gran Turismo games offload graphics computing onto it, because the RSX GPU was not enough by itself to keep up with the demands that were required by the games; I need to find the article that cites this information where I read it and update my post accordingly, or if someone else can find it, I'd appreciate it.
While the console had eight SPEs (Synergistic Processing Elements), Sony deliberately disabled one of them to get a better yield out of the chips they had manufactured. It's actually possible to unlock the eighth SPE, but at the risk of the console's stability of course. I find the PS3's hardware so very interesting, because in order to get the best of the console, you need to work in tandem with the CPU to get it to push out as much raw power as possible.
I think the Gran Turismo games are a very fine example on what the console can do at its utmost potential. There's been some other impressive titles such as Namco's fighting game franchises (Tekken and Soul Calibur) that keep the frame rate locked at 60 FPS while sparing little to no expense for detail, especially Soul Calibur V which still looks gorgeous even today on what most would call dated hardware. Grand Theft Auto V is another feat; a game as detailed and as complex as that, I would have never imagined it would be possible on the PS3, but the developers wrangled their talent to make it happen, and I'm sure the Cell CPU proved to be invaluable with its strength to make it happen as well.
There's also the Uncharted series, which was initially developed by ICE Team (now known today as Naughty Dog) who was basically a first-party low-level development team that knew how to master the PS3 hardware with their development techniques simply because they helped create both the hardware and the software development kits that other developers would use later on; with the release of The Last of Us in 2013, they went onward to solidify their proof of mastery with probably one of the most (if not THE most) impressive-looking titles on the console.
I doubt that the level of detail achieved by any of the aforementioned titles was obtained by solely relying on the RSX GPU alone. There's a lot of other great examples, but that'd be too big of a list to include in a post as small as this!