Colorado is in some ways a lot like Minnesota.
Major research university and state flagship located in the state's largest media market. Similar sized states and largest markets, which both have all of the four major pro sports.
CU football glory years were more in the late 80's to mid 90's I believe. Lot of Big 8 and then early Big 12 years. But since then, like the Gophers since the 60's, not a lot of major success.
Their campus is not right in the core urban area, though. Their location relative to downtown Denver, would be like if the U (of MN) was located in St Michael relatively to downtown Minneapolis.