Not quite sure what RDBMSs you are comparing Postgres to here... Firebird? Microsoft SQL/Sybase? Oracle? Because none of those strike me as particularly "simple" products?
I think most people struggle with setting up postgres auth. Personally, I find postgres' auth well designed.