You can turn the light off in the AirPort Setup Utility...I don't remember exactly where though. The light will only come on when there is a change in the status (like when it's starting up).
And yes, I'd probably refrain from unplugging it every night anyway.