I lived in Seattle from 1991-2000, and have been in Minneapolis the past 25 years. So my home stadiums were the Kingdome and then the Metrodome/Glad-bag-dome for many years, until Target Field was built. Horrible venues to watch a game (Target Field is excellent)!
I'd never want that for Detroit either, but perhaps a retractable roof would have been useful for poor weather