In the movie "Michael Collins" the director decided to have Julia Roberts sing "She Moved Through the Fair". Too bad Julia couldn't carry a tune in a bucket. It was the most painful 20 minutes of what was otherwise a great movie. (OK, it only seemed like 20 minutes.)
Honestly, the worst covers are when it was a good song to start with, and some talentless hack ruins it.
-MudWeasel