There was one game that probably first introduced me into such a thing, but I didn't really consider it until a year or so after I discovered what ryona was. It was called "3D Ballz" for the SNES and Genesis. It was quite a strange fighting game with strange controls and presentation. The whole thing wasn't really great overall. Thing is, all the characters were formed together with 3D balls and took shapes of humans or animals. When defeated, they would explode and scatter themselves on the fighting arena. There were female characters that would make this somewhat sexual groan. In combination, you'd have a female character who would explode upon defeat and make a sexual groan. Looking back on it, it's... uh... quite something to say the least. Here's an example:
Ballz 3D (SNES) Playthrough - NintendoComplete (At 2:00 Timestamp)
There's one from Tomb Raider II that I forgot about until I saw this thread. Revisiting this, it's actually somewhat nice to see again. If you watch it in slow motion, you can see each piece of her:
Of course, of course. As expected of me, there is one for Resident Evil 6. There is an explosion, but nothing remains afterwards. Somewhat disappointing in my opinion.
And the last one I've got is from The Evil Within with Juli Kidman. There's a creature in the DLC for Juli's campaign that explodes and causes Juli to burst into pieces if she is caught in the explosion. Probably my only favorite moment in the DLC really. You can see her in pieces here: