I run it on a Hetzner vps with 4 vcpus, 16gb of ram that's also running multiple other containers. I haven't checked recently but most of that ram is free.

I'm not going to claim nextcloud is the snappiest app but I can open it right now, from across the world from my server as I'm on vacation, and it loads in <5s. I haven't done much tuning.