His movies — from dramas to comedies and musicals — became magnets for Oscars, but he was best known for socially conscious films, like “In the Heat of the Night.”