Concerning the Vikings stadium, I honestly don't know if its going to get done, but I know if it gets done, building it in Arden Hills is a stupid idea. I know why Ziggy wants it there. He will make a shit ton of money off of it, but the public really wont benefit all that much due to the lack of hospitality businesses around there and lack of transportation.
I really like the idea of building it on the Farmer's Market site since it is right next to Target Field and the Target center, very close to the existing light rail and will be on a future planned light rail path. Its also on a major bike path. I think that area would make a lot of sense since you would basically create an sports and entertainment hub thanks to the three stadiums, first ave, and all of the surrounding bars. Plus, the area around the farmers market definitely could use some investment
http://www.ballparkmagic.com/_resources/FarmersMarket.pdf
good site showing the benefits of it.