What sort of things are most people doing on their desktop computer that needs more power or RAM though? I can't imagine.

You can still buy woefully underpowered laptops with hopeless resolutions and with 4GB of RAM running Windows 11, and that is a horrible desktop experience. At least with this it is a usable desktop machine, where the normal bottleneck was IO speed.