To me CF Workers are more about interacting with the CF CDN, doing lightweight HTTP stuff, etc. I would never use Workers to build a full server application. Their custom runtime locks you in, it's extremely barebones, and obviously almost no NPM modules are compatible.
They are working on Node compat which will probably help but I feel CF hasn't been investing enough into their cloud products (Workers, Pages, etc). DX is still hit and miss and progress overall feels glacial.
You can also use Deno Deploy (https://deno.com/deploy), if you want a Workers alternative but don't want to self-host
I know the corporations I work at are very anti-node.js and very pro-C# and everything needs to be approved by a tech committee. I don't think we could get Supabase approved (and instead we fork millions a month to Azure instead).
Just a bit of feedback. I'm not a fan of C# or Java at all these days given how good Rust, node.js/Typescript/Deno have become. I just now work for 40,000+ person companies where I know this would be a non-starter unless you were super lucky to get all approvals aligned and be on one of the "cool" team.
Maybe not the pivot/user feedback that aligns with your goals. :D
The idea is that you'd just use the client libraries in your favourite framework.