The CO version of public health does not currently cover home birth. They will cover a natural birth with a MW, but I know that isn't really the same. There is a large and active MW community here so you might be able to find a HBMW who is willing to barter with you or do a sliding scale.
Boulder is an interesting combo of the largest university in the state, wealthy tech business, and outdoorsmen. Yes, there are also hippies, but honestly I think it is the place to go to see BOB strollers, Northface coats, silk baby slings, and $150 sandals. In other words, there is a natural community there, but it is mostly an affluent one. Home prices are steep, but you could most likely get family student housing. If you are a skier, Eldora is an easy day trip and a decent slide. Denver is also just 30 minutes away if you want the zoo, theater, etc.
Fort Collins is a little different. There is money here too, but maybe a little less. The Uni is smaller, so the party scene is also a bit smaller and more confined to the areas near campus. People here bike, hike, paddle, etc., like those in Boulder, but are more likely to also hunt, fish, and own an ATV, truck, or boat. Skiing is at leat 2 hours away, so a day trip with the kids is a haul. Denver and all it's attractions are a little over an hour away, so not as convenient. Fort Collins is a little more relaxed in it's style. You will see fewer top end cars and gear, and more people just making do with what they have. Personally, I prefer the NoCo vibe which is why I live here.
Both areas have excellent schools, including Montosorri and Waldorf. The public schools in therpse two areas are also ome of the best in the state. There is a homeschool connection organization in Boulder. Not sure if there is one up here.
Ys, you can opt out of vaccinating for "personal opposition to vaccines.". It is somewhat funny because you still have to submit a vaccine record (blank, if they have had none) but that's it.
Unless you get into family student housing there is no way you will find a property with 2 bedrooms and a yard for $800. In student land, that will run you closer to $1000 or $1200 min. If, however, you have a car then yes, you can find that, but it will be way out of town.
Honestly, I would make the decision based more on your DH career path than on the area. Both are nice places to live. CU is huge with a variety of decent programs. CSU is smaller, but has certain areas in which it shines. UNC (Greeley) is the best school for Education degrees, while Mines is excellent for science/technology stuff. Good luck with your decision. It's hard to choose from a distance!
Hope this helps!