The singer-songwriter deserved to be far better known in his lifetime – but reticence and mental illness contributed to his tragically early death in 1974