Personally, I detest the gore of CSI and the gratuitous bloodletting of some movies.
If I remember my psychology classes, there is a physiological reaction to gore, but taken to the extreme, you become desensitized and blood and guts provokes a laughter response.
South Park understands this phenomenon and they deliberately overdo the gore for the humorous effect, like the epic "Whale Wars" eipsode:
Face it, sometimes gore is so extreme it's actually hilarious!
It's the opening scene of the movie "Ghost Ship", very creative!
WARNING - Funny gore inside