Comment by hrns

And instead of buying more powerful hardware you can try to get the always free oracle VPS (4vcpu ARM, 24GB RAM, 200GB storage), do your compute stuff there, and keep the RPI as pi-hole/home assistant only. It will save you on electricity bill as well.