My Switch Lite whines when it's booting, but that only happens during the Nintendo logo screen.
Right after that, screen goes to black and then when the Switch logo appears, the whine is gone.
After entering sleep state, if I attempt to wake up the handheld soon after that, (5 to 8 minutes after...