I like the idea of a self healing cluster where each node is equal and the amount of work required to maintain and migrate it is kept to a minimum.

I misspoke, i meant with moderate latency requirements. I have a product in mind where the queries don't require high performance. Instead i value availability without babysitting.