No Fade Sims and Objects by Shimrod101

This mod removes the camera fade on sims, objects, trees and shrubberies when zooming in close. It doesn't work for ceiling lamps and columns for some reason, presumably these objects have their own settings in other files.

Mod The Sims