Generally...if you want good water you have to go private, up in the mountains or else be out there before or after everyone else is on the water (*early spring, late fall). If you are coming from somewhere where you took good water for granted, it will be a bit of a shock.
My favorite place, by far, is lake granby and grand lake. Bring your drysuit though.