"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.)
But in this case at least you are using PostgreSQL outside of anything even remotely purely relational. It is at least object-relational, and often key-value-id (like hstore) or document store (JSON or XML).
The power of PostgreSQL occurs from the power to ignore the relational model and take other approaches when it is helpful.
I also think the best way to look at NoSQL is that it is just a further development on Stonebreaker's bottom-left quadrant database division--- object databases.
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.