and my UPS is not very reliable (time for a new one).
Make sure your batteries are good. They need to be regularly replaced every 3 - 5 years. Weak batteries make for an unreliable UPS.

But new batteries are cheaper than a whole new UPS.
They all screw up the performance and stability of Windows at some point. So no I don't use them.
Totally disagree with that! No way sleep affects performance. As for stability, on
rare occasions, a computer will not properly come out of sleep. Typically a simple reboot resolves that. But once a computer boots properly, sleep mode does not interfere.
Sleep mode is nothing new. Microsoft and the applicable hardware makers have had over 20 years to sort problems out.
I beg to differ. Hibernation is for whatever situation hibernation is needed for, be it on a desktop or a laptop. For instance, desktop users who suffer from frequent blackouts would rather opt for hibernation instead of sleeping.
Sorry, but that makes no sense. First, hibernation was indeed developed for notebooks - so when you close the lid, you can resume exactly where you left off. Yes, you can use hibernation with a PC and you can use hybrid mode on a notebook But hybrid mode was developed for the PC.
Second, if a user suffers from frequent blackouts they should definitely be using a good UPS with AVR. Note I've lived in
Tornado Alley for the last 28 years so I have some experience with that. But more importantly, if a user suffers from frequent blackouts and they don't use an UPS, they should be saving their work and "gracefully" shutdown the computer, not put it in sleep mode.
Lastly, hybrid mode is called
hybrid mode because it is just that, a mixture of modes. In hybrid mode, data stays in RAM (in a low voltage state) for faster wake times. But in hybrid mode, a full hibernation file is also created in case the user (or Mother Nature) decides to remove power completely.
A full restart every once in a while is recommended, but I think that Windows has come far enough that it can last a considerable up time before the need for such measures.
Newer versions of Windows are not XP. So true, there is no need to reboot Windows just because it has been awhile since the last reboot. I only reboot my 6 W10 systems when some Windows Update or security program update requires it.
Care to expand on the "things get left in memory" part? As far as I know, Windows marks any memory space as available for use once the program that uses it terminates, no exceptions. Memory leaks from buggy programs can be cause that symptom, but that's not an issue related to the OS and power states in themselves.
Memory leaks should not be part of this discussion. Those are faults and exceptions, and very rare. Exceptions don't make the rule. If a program is that buggy, get rid of the program.
As for things left in memory, as I noted above data is indeed left in memory to speed up wake times from sleep mode. Remember, unless you unplug the computer from the wall (or flip the master power switch on the back of the PSU - if it has one) your PC is in "Standby mode" and +5Vsb standby voltage is being distributed to multiple points across the motherboard.
If you terminate a program, that memory space is freed up. But if you keep, for example, a Word document open and allow your computer to sleep, some of that data will be retained in RAM for quicker wakes.
See Fred Langa,
Is Data Safe in Sleep/Standby/Suspend Mode?