The worst one in recent memory is THE 10 COMMANDMENTS The Musical with VAL KILMER. At the Kodak theatre in Los Angeles. They announced it would go to New York--I don't think there's much hope for that.
The ones I remember from the past are "Promised Valley", a Mormon musical I saw in Salt Lake City years ago. It ran at the Promised Valley Playhouse every summer for years, and another Mormon musical "Brigham" that I saw at Brigham Young University and which had the lyrics "All shake hands in a great big circle, all shake hands in a great big square. All shake hands 'til your knuckles quirkle..." It's stuck in my memory forever.
Interesting, they all have religious themes.
Yes, we do need a third vampire musical.--Little Sally, Gypsy of the Year 2005.