The Ramones covering CCR's "Have You Ever Seen the Rain?". The Ramones did a really good job. They sped up the tempo, but not so much that you couldn't understand the lyrics.
Some of my other favorites have been mentioned...
I also despised Korn's "Another Brick in the Wall". There's a special place in the afterlife for people who butcher Pink Floyd...