"The more I get into it, the more I am astounded with the power of PostgreSQL to take over all these workloads on the low-end and more."

Exactly. When NoSQL "honestly" say, oh nooooooooo we're not replacing the traditional RDBMS approach, this is anything but honest.

It's like me building this suspended-rail system for inner-city transportation. Oh noooooooo I'm not replacing traditional cars and bicycles!

the way you get acceptance is by faking honesty that you're not at all replacing the traditional approach (that you're replacing.)