you can still do schemafull databases with NOSQL databases but its in your hands to do it or not do it. All the problems you list you can have on SQL databases

you can still do schemafull databases with NOSQL databases but its in your hands to do it or not do it. All the problems you list you can have on SQL databases too It has to do with discipline to keep your data clean not with SQL or NoSQL