I had one from 2010 and the bright light wasn't even the main problem at night.
The charger emitted an annoying high pitch sound so I'd have to unplug it.
And the device turned itself on randomly at night, and the CD-ROM reader and fans would spin up and make noise.
I've now used a macbook air for work and I noticed that even when in "standby" for a week my router had a DHCP lease for it. So they still turn on for no reason, but at least the lack of fans and the fact that I can now use a decent usbc charger means they don't wake me up any more.
You can disable it but yes macs will periodically wake up to get emails and notifications even while they are ‘sleeping’