Yah, I have had many projects where I could have used something else, but Postgres ended up being the perfect bag of tools to do what I needed. I've been very happy with it.
I can understand. I started to grasp the full potential of Postgres (but probably I'm still missing a lot) when I decided to use it for time series with the Timescale extension.