Michael Madsen was recently sober when he died, having finally overcome his years-long battle with alcohol, according to latest reports; He is pictured in 2023