Anyone know much about Boulder and Denver real estate?

We’re planning a trip in March to explore neighborhoods in and around Boulder and Denver, Colorado—to plan a possible move there next year. Can anyone please share insights on neighborhoods and towns in and around Boulder and Denver? Is there just one downtown/commercial area, or several? Better/worse neighborhoods? We have two kids ages 6 and 3 and my wife is a doctor and will likely be working at the medical campus in Aurora or Denver. I hope to be selling bagels from a cart somewhere—or something else that requires limited human interaction. Thanks!