Not... really? It's no more difficult than finding the correct buffer sizes for nginx, or finding the correct sizes for the ebpf connection table tracking map if you're using cilium on k8s, or kernel tcp buffers or any other other myriad services one could run.
Being a bit obtuse to tune doesn't really justify going all-in on cloud. It's all there in the documentation.
But that said, you can afford a lot more hardware if you’re not using RDS, so the tuning doesn’t need to be perfect.