I will try to answer some of the questions. We usually don't stay over night. Fayetteville is 2-1/2 - 3 hours away & a horrible drive, but there is little traffic early Sunday morning.
The Residence Inn JRead mentioned is right across the street from the stadium. There are many other hotels downtown that are very close by (well within walking distance). There are many restaurants/bars downtown. I know of no strip clubs down there...lol.
We are usually in Charlotte by 10:00 or so & tailgating has already started.
If you decide to drive up on Sunday, there are many lots available for parking. They get more expensive the closer you get to the stadium. I believe we usually pay about $15.
Hope to see you there!
Jan