Matte painting can be used for post lighting the scene. One usual use would be, Day for night,
Day for Sunset and Enhancing shadows.
By painting a Z channel for a real footage, you can also gain more power in 3D compositing.