Two of my most recent were in Dragon Age: Origins: Leilana's Song and Borderlands: Secret Armory of General Knoxx.
In DAO, you get to a point where a Mabari Trainer and his Four Mabari are waiting behind a door. With the fairly bad characters you're stuck with, this is a pain. After dying quite a few times, I finally, frustrated, started casting Tempest through the wall, and to my surprise, heard the Mabari whining and watched damage being counted through the wall. So I slaughtered them through the wall.
In Borderlands, I had an extremely lucky find of a "Bastard" Rifle, which regenerates ammo, does insane base damage, insane criticals and has a 180 capacity clip, as well as firing full auto. So when I got to Knoxx, I was getting aggravated as his attacks kept killing me, so I decided to pull up my scope, and hold down the trigger while aiming at his head. Thus followed a steady string of criticals and Knoxx stumbling until he died. SWEET.
-Raptor, out.