I haven't personally used RSCs in production, but joist-orm.io/blog/nextjs-... is a sample app that shows the N+1 prevention works when server-side RSCs are "rendered in a loop".