I just listened to the End of the Rainbow and it's indeed a dark song but it's really good. I then went searching for the entire I Want to see the Bright Lights Tonight album and have been listening to it ever since. The entire album is some really good listening and some songs are very dark but still quite enjoyable to listen to. The song Withered and Died even though it's a great song is to me the darkest and most depressing song on the entire album.
The songs that have stood out for me from my brief listen to the album as been:
The Calvary Cross
Withered and Died
I Want to See the Bright Lights Tonight
Has He Got a Friend for Me
The End of the Rainbow
I'm sure the more I listen the more I'll also enjoy the rest of the album as well. Linda Thompson's vocals are really fantastic combined with Richard's great guitar playing. Thanks for posting and bringing this album to my attention. It's really worth a listen.