Agreed, if you don't mind getting locked into a platform, AWS, Azure, and Google all have options for varying no-sql/search and/or big-table data stores... but ymmv there.
I hear ya! I'm ultimately going to go with the strategy that you've mentioned. NoSql+Sql with Google and just write my ORMs and wrappers. Thanks for the advice!