Sleep is a very low power mode. AFAIK, the only power is used to maintain power to RAM.
Anything that uses a lot of power - fans, drives, etc - do not run at all during sleep.
So, if you sleep your Mac, then it's not "running overnight" at all.
However, if you mean "sleep the display" - then only the display is off (backlight is off, and no video to the display), but other power remains on.
There's really different ideas about leaving the computer on 24-7 (and not sleeping during hours when not in use)
Although you use more power, leaving power on means that you don't have to start up your Mac when you want to use it.
That's when the most stress is placed on the system, due to small power surges as various parts of the system get powered on from completely off.
Waking up, from sleep mode, is much less stressful on the hardware, and waking up the display (from "display sleep" mode) is somewhat less stressful.
So, my opinion, if you use your computer every day, then shutting off completely each night puts more stress on the system, compared to other power modes.
And, sleep mode gives you a real advantage - as you can go to normal use within a couple of seconds, where a complete power off means waiting the full boot time until you can use your Mac (along with somewhat more stress to the system for a full boot)