The actor, who has died at the age of 80, will be remembered by fans of many ages for wildly varied performances in films including ‘The Rocky Horror Picture Show’, ‘Clue’, ‘It’ and ‘Home Alone 2’, writes Kevin E G Perry