I've gone through that list before, but never find anything compelling enough to pull me away from psql (the built-in CLI client).

I highly recommend learning psql first. It doesn't have every feature you might want, but it gets the basics right and is easy to integrate with your editor and other tools. As far as I can tell, it's what most professionals use.