I've cut costs by an order of magnitude by changing back to old school dedicated servers. ( using the same data center that aws/google uses, equinix )
IOPS on aws is ridiculous expensive
2) Sure, as a DBA, I prefer dedicated servers with SSD. If you don't have a DBA, then RDS/Aurora are ok too.
For production, ensure you have a replica either way. MySQL 8 has multi-master now (or use Percona Server/Galera), so you can easily enable HA, and I'm sure Postgres does too.