There is not a great deal of diving in the Colorado area. During the winter months, I generally go down to the Blue Hole. MN (SantaRosa) a few times just to get some dives in.
As you have done Aurora, then you understand what poor conditions we have. However Aurora in the Spring can boast vis of 20feet! However the water is cold, and a drysuit is not a bad idea. There are some lakes I have not done (Jefferson beiing one) that seem to hold a bit of promise, however they are very cold when the diving is likely at it's best which is right after the ice melts. DrySuit diving to be sure unless you love 40F water in a 7mm fullsuit.
In any event, check out the Rocky Mtn. Oyster forum if you are interested in hooking up with local divers and diving in the area. Not sure how long you are here, but Tampa is going to be a LOT better location for diving, even if I think the East Coast of FL is really where to go IMO.
Welcome, and enjoy SB. There are a lot of good people here, and I've dove with many in CO, NM, and FL who I met on the boards.