You say "gaming consoles", but really I think I've only seen it in the Xbox 360. Was it deployed anywhere else that I missed?
We use these features to store small amounts of very sensitive data, key material for example.
As far as I know the only two systems that use cryptographically meaningful memory encryption are Xbox 360 and zArchitecture mainframes.
Various secure crypto processors usually have some support for external "encrypted" SRAM, but as this typically involves microcontroller platforms and byte/word-wide accesses to said memory the implementation in the best case boils down to CTR mode (usually of some secret semi-proprietary algorithm of questionable cryptographic qualities) without IV or any authentication.