I used DBeaver for a few years until I got tired of giving 50% of my machine's resources to it, then switched to TablePlus and have been quite happy. I've never needed more than two tabs so I've never paid, but I absolutely would pay them (it's great).

If I was looking for something new right now, I'd try DataGrip first. I'm a huge fan of Jetbrains' products so I'd be happy to pay them for another useful tool.

Just my 2c. I'm sure others have different experiences/likes/dislikes