If you are from RDBMS, at first you will have to become flexible to accommodate to the BigTable way of things - no group-by, joins, etc., - and find alternate ways of doing things. Once you make the switch, if will indeed be good enough for big or highly scalable projects.
I believe it is and am betting with my startup with hosted apps targeting SMBs with CRM (http://crm.ifreetools.com) and Online Database App Creator (http://creator.ifreetools.com).
If you are from RDBMS, at first you will have to become flexible to accommodate to the BigTable way of things - no group-by, joins, etc., - and find alternate ways of doing things. Once you make the switch, if will indeed be good enough for big or highly scalable projects.