Lots of good info here. I don't have too much to add.
Like many cities that are 'up and coming' these days, you have a few options.
1. A place 'in the country' that's gonna cost less, give you space and take a while to get where you want to go. low $/sq. ft.
2. The close to downtown/urban and semi urban neighborhoods. higher $/sq. ft
3. The burbs (often in between 1 and 2). lower $/sq ft.
I live in the same-ish neighborhood as SgnDen - North Highlands/Berkeley NW Denver. I'd call it a #2.
When we decided to buy it came down to a few things - community 'feel', commute to work and whether or not we liked the place (I had requirements such as a garage, my wife wanted a dining room etc.
Well, we ended up in NW Denver and I've almost made the move to the a #3 burbs since, just to get a larger garage, bigger basement etc. Those places are just a lot more expensive in a #2 area.
However, I just can't bring myself to do it. I really hate driving around down in the Littleton/Centennial area. It doesn't have any of that 'community' feel we have up here NW (maybe it's neighborhood pride, I dunno, there are a lot of things I don't care for about my neighborhood, schools for example).
I work in Golden, so my commute is only about 25 minutes door to door. That's nice. The direction I travel on I70 doesn't have too many issues usually. For a while I took I25 as part of my commute and hated it. Just absolutely hated it. Make sure you don't subject your wife to an I25 commute. Trust me, it's the pits.
If you're in the Golden Area, check out the Applewood neighborhood. Depending on how things play out for us in the next couple of years, that's possibly a contender for our next move. Older homes, in a good way. But it can get mixed up pretty quickly.
Ideally, I'd find us a place out west here with an acre or two. But it starts getting expensive really quick when you start looking for acreage/horse properties along the front range.
For example,check this out, 3 Bed, 1Bath small house on 5 Acres. Only half a million.

Gulp!
Land and location come in strange combinations out here.
1195 Isabell St, Golden, CO 80401 - Zillow
There are some nice spots in Arvada too. Kind of mixed up neighborhoods, but nice.
Check out zillow.com. It's fun.
Oh, and if you visit Golden, I'd skip the Coors brewery. Better breweries to visit, especially if you're here on a scouting mission.
Cheers!