Local and Semi-Local Density Functional Approximations for Exchange and Correlation: Why Do They Work, and Do They Work Best at Zero Temperature?