Cloudflare edge backends are supposedly really fast. Stuff like kv, durable objects, hono.js mixed with your frontend framework of choice.
But I feel like for 10 or so pages it won't really matter what you choose.As long as your queries are good you should be fine.
Edited to add links:
https://blog.cloudflare.com/cloudflare-workers-serverless-we...