It's a great choice for higher budget applications too. At my job (public tech company, former startup), we use Postgres as our source of truth for just about everything that should go in an OLTP database (e.g. not analytics). I don't think there's another database product that would work as well for us as Postgres.

You’d think, but people certainly still choose MySQL these days, and without a really serious reason to other than familiarity.

By all means, use what you’re comfortable with but not having stuff like transactional DDL feels backwards at this point.