The musician and actor passed away at his New York home on Friday, after battling stage four cancer, a brain tumour and a broken back