(Neon employee) We auto-upgrade minor versions as long as they can be done autonomously. For major versions, you're right it's still manual but we're working on improving that. Here is our version policy:
https://neon.tech/docs/postgresql/postgres-version-policy