Aware Postgres is free: it's an excellent database and I've used it successfully (like most of the other tools I've mentioned.) It also has spectacular failure modes; though the only ones I've personally encountered were around vacuuming.
How often did you manage to spectacularly fail PostgreSQL to qualify it an 'operational nightmare'?