If you serve and carbonate at the same pressure, which for most of us is going to be around 12 PSI, then shaking at that pressure setting cannot possibly lead to overcarbonation. Where people run into trouble with that is setting at a much higher pressure, typically around 30 PSI and shaking. That can, and often does result in overcarbonation. This comes down to people who are new to kegging not really understanding the physics that are involved with forcing gas into liquid. Those who understand what is happening and know what they are doing can make this work successfully, but the novice is asking for trouble.
All kegs will eventually clear over time. Kegs in commercial settings will often be consumed before the yeast and wheat flour has had time to clear. On the homebrew level, I've seen where some people will add a tablespoon of flour to the beer prior to kegging to help maintain the cloudy appearance. Of course, this won't give the same flavor as yeast, but it will at least look like it has yeast suspended and will maintain that appearance quite a bit longer.