Super Mario 3D Land used it very effectively, and I'd say it made Ocarina and Star Fox look damn pretty too, especially with all the particle effects flying around in those games.
I have to disagree on Resident Evil though. It didn't look bad in 3D, but I certainly wasn't impressed by it. It was just sort of there. Ah well. --- Work is for people who don't know how to fish! 3DS Friend Code: 1289-8728-7299