Using the Light2D and CanvasModulate nodes, you can effectively tint 2D art without having to modify it manually. However, you may still want to use nighttime versions for certain sprites such as lamps, lightbulbs, etc. You don't want those to be powered on during daytime :)