If I recall, he ended up homeless and living on the street until some group bought him a trailer or something.
I think that was Lester Chambers, who it seems barely saw any royalties from his one big hit.
The only bad thing I heard about Sly was that he was busted for having a piece in a nightclub in Ft. Myers, FL (iirc). Or some such.