The concept sounds great. Taking the roof off the Silverdome, cutting the stadium essentially in half and making it an outdoor stadium with natural grass. (see story: http://bit.ly/xxPJPK)
The one concept I don't know if it would work is the part about an MLS soccer team in this area.
Look, I bash soccer a lot, but much of it is done tongue-in-cheek because the people who are really into it tend to exaggerate its scope compared other sports in this country, and particularly in Southeastern Michigan. It is not going to take over for baseball in this nation, or hockey in this area. It's huge world wide, but a relatively small niche sport here. It's like once a year there is a some soccer moment that happens that is allegedly going to set it off in this nation. It never really does.
The game does have appeal, but it's limited and it's not the MLS. It's more the international game. The World Cup. The European Championship. The elite leagues in Europe. The MLS is a dud in comparison.
I did go to the AC Milan game at Silverdome in 2010. It was an excellent game. I enjoyed it. It was surreal at the Silverdome - like being dropped back into the early 1990s or something. The facility is badly outdated. They also didn't do a good job that night getting people into the stadium because the lines for security were incredibly slow.
But it's a good thing somebody owns it. It's a good thing they have interest in doing something with other than tearing it down. I wish them luck, but...