Bullet in the back of the head from a jealous husband.
But it would go through your head and into the wife you were "entertaining," killing her as well.
Now that would be the most ultimate "rock star" death imaginable.
Well, either that or while on the toilet - Elvis style.
