Interesting points raidicy, as an engineer I would have similar requirements and really don't like seeding control to third party products :) But then, a no-code almost non techie type, might just want to get something working
It's also worth looking at https://supabase.io/. Imo their route generation and automatic documentation is great and could be an inspiration.