I've been to Ford Field for football games, the Rolling Stones ('05), and the NCAA hockey championship game a few years back.
I have NEVER had a good experience there. Staff is astoundingly rude, traffic and parking are nightmares, and prices are ridiculous.
U2 is probably the one event that could get me to go back.