As you have noted, it can be either good or bad.
Unfined and unfiltered Chardonnays, like Kistler and Martinelli, frequently look cloudy. It's a good thing.
Rule of thumb: if you have a cheap wine that is cloudy, chances are it's a bad thing.
Sometimes, whites that get too cold seem cloudy -- it's a toss-up as to whether good or bad...