So what's the goto replication software to use for MySQL or Postgres these days?

I would definitely say pg-auto-failover[1]. It's the only one that doesn't have a ton of moving parts, and it helps you get a good base setup too at the same time.

[1]: https://github.com/citusdata/pg_auto_failover