https://www.spacebar.news/p/windows-pc-sleep-broken
The Modern Standby feature in newer Windows PCs never seems to work right.
Like the other replier and GP, my Linux and Mac desktops run for months at a time without a restart. I only restart when there's a software update that demands it. I don't have much experience with modern Windows, but I expect that's the norm from a modern OS.
If you're running into runaway resource issues like this then you may want to spend a few minutes hunting them down and maybe replace the programs responsible. Daily restarts shouldn't be necessary.