OR sleep, it's not a security issue, as nothing can happen, unless it powers back up remotely from a signal that comes in, which is highly unlikely, especially if you have proper security measures in place. You also should turn off remote support in this scenario, since you can always turn it back on if you need to.
As to whether to power down for other than saving line power, it makes not a bit of difference nowadays.
We have a home PC that has been running pretty much constantly for 8 years, and no problems. Most people replace their computers much more often than that.
Hibernate, rather than sleep, actually puts much more stress on a system, and I tend to avoid it because it does so many write cycles to the drive, taking forever to finish. It does, however, put your data from current session to the drive rather than residing in memory, so that one is personal choice.
Sleep is much faster if that's a consideration (pretty much instant on, instead of waiting.)
Consider, also, that if you have automatic updates turned on, or defrag or an antivirus system scan scheduled for the middle of the night, that these tasks won't happen if you turn it off. That, nowadays is the single most important consideration for leaving the computer fully powered up. If you know when updates, defrag, and system scans are scheduled, you could leave the computer on at those times, and shut down other nights to save power.
My father used to shut his Windows 98 computer down whenever he wasn't using it, and his filesystem was completely screwed up from this, as these tasks never occurred, or tried to run in background when he was using the computer the most heavily. He complained the unit was slow and buggy. I told him, leave it on, and the three tasks mentioned would then be able to be performed when he wasn't using it, and the speed and reliability vastly improved!
Basically, however, for the typical user, there are times when you need to leave it on, updates, defrag, and system scan. With modern computers this whole issue isn't so much of a consideration, but if you still have a computer 10 or more years old, you probably need to pick and chose when to leave it on, unless you are using it as a server that needs to be constantly available.
Typically, however, if you need to store files on a common drive, an external hard drive is a much better option for a home user, and they are very cheap, 500 GB for $50 or so, rather than running a power supply and all the associated hardware (and vulnerable software) for a laptop or tower.
Hope this helps someone out there.