Both on and off the screen, the actor, who has died at the age of 46, was open about his love life and romantic interests