William Whyte’s “The Social Life of Small Urban Spaces” is probably the best urban design/sociology film I’ve seen. It may feel outdated, but the points he makes are still very valid today. You can see the whole thing (in parts) via YouTube.