I can't think of many from the past, but more recently in Oblivion I hit a rat (I think it was; mabber a dog) so hard that it flew up into a casket in the nook in the wall of a cavern, as if someone put it in there.
Also, there's a quest where you get into a dinner party and cast Stark Reality on everyone, which removes all their clothes and items within range (including your own). They become pissed and chase after you, along with every guard in the castle you come across. The only thing missing is Yakety Sax playing in the background.