Tim Curry -- the legendary film and TV actor best known for playing Dr. Frank-N-Furter in the cult classic "The Rocky Horror Picture Show" -- has died ... TMZ has learned. Sources tell TMZ the actor -- who had been plagued with serious health…