Hey there - I'm CEO of Payload (YC S22) [1] and you're speaking my language.
We're an open-source CMS where you completely own your database. Right now we're MongoDB-only, but we are actively working on adding Postgres support and that should be done VERY soon.