"build a homelab in your own basement, rent a cheap VPS, set up wireguard and viola"

Put an openwrt router in front of your fat server, and for each query it sends a WOL packet to the box, and add some delay to an ethernet bridge.

That was the fat server is mostly sleeping, and only woken up when needed.