While I have had my far share of head-scratchers trying to find the proper setting for x, I would certainly disagree that DataGrip has one of the worst UIs. I have used it daily for the past two years with a variety of databases (MySQL, Postgres, and Redshift for the most part), and honestly it seems like the best tool out there right now.

What tool is your preference?