Just curious, or is it just me that thinks all those mentioned so far are at best mediocre hack jobs?

You may well be right - many of these lyrics were probably written to try to cash in on the popularity of an existing tune. In most cases, the public didn't bite, and these discs flopped (never or underestimate the public's taste - but never overestimate it either! :-))