“He was a titan, a giant. He could have been as famous as any songwriter in the world, but chose not to be”: The doomed singer who played with a world-famous comedian and had one of the most famous hit singles in history – but couldn’t escape his demons