We use Aurora for MySQL apps and love it. The PG-compliant variety is not available in our regions, so can't put it through real testing by ghosting requests yet.

IMO RDS is perfect for most use-cases. I'd strongly encourage to try it out - it's highly performant and very reliable (uhhh... well...). Aurora has a significant edge under very significant loads (i.e. >300 concurrent clients), but can be slower under typical scenarios (0-100 concurrency).