Some operators for postgres is free for non commercial use, so its not truly open source even though its source available, one is crunchydata.
pgvecto.rs v0.4.0 I assumed was just not renamed. They have one for vectorchord too
Operators are good ways to support applications in CLI that aren't easy to setup in a cluster by default. You can make these databases redundant by setting replica higher than 1 and applying it, operator copies the db data and makes a new replica. It also helps with backups and restoring too.
Yeah operators are extremely nice. I used bitnami images before operator in HA setup and it would fail all the time. Using operators I have like 12 postgres DBs and 0 issues for well over a year.
Btw, self hosting communities tend to shy away from k8s due to complexity and generally enterprises use it so less selfhosters use it. I wanted redundancy and to keep me learning tech, less crazy people tend to go with proxmox for clustering in these communities.