I'd go the NUC, not necessarily Intel though. I bought an early i7 Skull Canyon NUC 5 or 6 years ago, I've got the OS & programs on a 500GB M.2 SSD, & another 1 TB M.2 SSD just for photos that I download and edit, before they get shuffled off to my NAS. It hasn't skipped a beat, it's still really snappy, I've run autoCAD on it without any trouble, it used to get chucked in a bag and dragged to work/on holidays, very impressed with it. Still going strong.
What I have just bought though, is a Beelink SER6 Pro 7735HS mini computer/NUC. It runs a Ryzen 7 7735 8 core 16 thread 3.2-4.75 GHz CPU, Gen 4 NVMe M.2 SSD, 32GB of DDR5 RAM at 4800 MHz, Radeon 680M on board graphics, USB 4, Windows 11 Pro, all for Au $825.00. It flies. It really flies. I upgraded the original 500GB SSD to a 2TB Crucial P3+ NVMe, & still came in at just under 1000 bucks Au. With room for another internal 2.5" SSD. What a steal. It's tiny. Really tiny. Roughly 12.5cm square, by 4.5cm tall. And for all intents and purposes, silent. Comes with a VESA mount bracket, I've got mine sitting on the back of my monitor. The ultimate couch computer if you sit it on the Coffee table with a Bluetooth mouse & keyboard. We'll see how it goes for longevity, they're getting faster and more affordable all the time. Check them out.