1) Water is a problem in many cities in America. I like this realistic aspect. You basically have to do what REAL cities have to do, import water or filter your sewege and reuse it. No idea why people are complaing about this.
2) Why is it self evident what the "right" amount of police is, or fire protection, or medical attention? There is no right answer to any of those questions, in real life, so why are people expecting to just look at a chart and plug in the "right" amount of fireman in game?
Also, our simcities grow a lot faster than real cities, so of course we are going to struggle with sewage, water, trash pick up, etc.
If you don't want to have problems, dont' expand your city so rapidly.
Build a small city with few zones areas, save up enough money to expand services, then add zones.
People are trying to go from 0 population to 200K population overnight, then get surprised when they can't handle all the challenges that kind of INSANE growth leads to.
3) Server issues are causing many of your problems. City #1 isn't talking to City #2 via the Cloud, hence you're having trouble with sharing resources.
4) The game is a puzzle, so don't get upset if you dont' solve it on day 1.