That really depends on the hardware and the quality of its firmware.
Got myself some refurbished Lenovo M910q Tiny with 32GB RAM and low-power (35Watt) Core i5-7500t and 7700t (Kaby Lake).
Upped one with Mushkin Essentials to 64GB, put new SSDs (1x Sata, 1x NVME) into them, and they are all fucking flying,
with all crappy mitigations ON, while staying mostly silent.
Everything runs on them without problems. Even Hackintosh which I tried for fun.
Switching them on or off via keyboard, or resuming successfully from suspend?
No matter if to RAM or DISK, works every time.
Virtualisation? Covered.
2x 4K via DP? Covered. Though at 60Hz only. (Don't care, don't have faster screens anyways)
LAN could be more and faster, only 1x 1GB. (Don't care ATM)
Could even be expanded via 1x half-length and low-profile
PCIe 3 x8, depending on the card and PSU. (Don't care ATM)
Any relevant video-codec is HW-accellerated, for de- and encoding. No sweat.
It remains to be seen if they'll still get BIOS updates for any new vulerabilities,
but again, I don't really care.
Excellent (small) homelab or automation stuff.
Depending on configuration they come from 200 to 300USD/EUR.
Edit: This stuff https://pcsupport.lenovo.com/us/en/products/desktops-and-all...