this is mostly a preference choice. drizzle is indeed pretty new so you will have less resources to use when you have any issues, but they are releasing new features and it is looking really good

so if you want something lighter than prisma and is aware that you might get stuck with some issues, you could give drizzle a try

1+ for drizzle

I use prisma, but ive heard drizzle is more efficient

just dont want to move to it

more resources, tutorials, and people who know prisma tho

according to this article, location of a Next.js and a DB matters due to TLS handshake time. if they sit together in the same AWS region, it won't be problem so much.
https://dev.to/zenstack/defend-the-truth-in-the-internet-age-5b7i