Since when you drown you still die of asphyxiation (suffocation), I would say that drowning is worse only because you would be completely surrounded by water. Unless being a true romantic goth you might welcome such and ending seeing it as being the most comparable to your life. (I dunno I'm soooooooooo stoned)
What's worse :
having sex with the dead,
or
the dead having sex.