Even an pi is basically in the same performance range as the average lowest tier cloud vm so if your considering something bellow say a aws t2.medium to be enou

Even an pi is basically in the same performance range as the average lowest tier cloud vm so if your considering something bellow say a aws t2.medium to be enough then your only real concern is if your app is iobound enough for the sd card to be a bottleneck and it's very likely that your app is not. If you want to go with a more traditional x68 any of the many intel n4000/n5000 series systems being sold on aliexpres and similar sizes by no name brands as firewall appliances or network something do support modern m.2/nvme storage.