We don’t like them in work, they’re:
Expensive relative to their spec.
Bulkier than a standard monitor.
Perform poorly compared to a similar spec desktop as they’re construction-wise far closer to laptops than desktops.
Surprisingly easy to “write off”.
If you want a ‘really’ small PC you’d be better off with a mini-pc, you can get them with i5 processors (admittedly slower laptop spec ones) and you can mount them to the rear of a monitor using the wall-mount points. They still have the draw-backs of all-in-ones but at least you separate the screen from the PC so it’s more maintainable.
Personally as so many others have said, get a SFF PC, stick it on the floor / shelf so it’s out the way, get a wireless keyboard and a decent monitor and that’s about the most robust set-up.