I've always found the most satisfying violence, although not necessarily gore related, involves wielding obscene amounts of power.
This happened more in older games like Rampage and Blast Corps, which still stroke the conquering barbarian part of my brain. The challenge in those games didn't...