The rocker died without any money to his name in a tiny council flat - while his former bandmates are multimillionaires