Durham has spurts of intense activity surrounding the Durham Bulls games and DPAC events. Other than that, it is usually pretty quiet. Raleigh seems to have a steady "crowd" that frequents the city on most days and nights. I personally would rather have the latter, but would enjoy some development activity in Raleigh that gives short spurts of massive crowds (Other than motorcycle weekend, convention center events, etc.). An addition of a decent downtown stadium would do wonders for Raleigh and now is the time to start planning. With rising land values throughout the core we cannot stand to wait much longer if we want this to become a reality. A mixed use sporting complex that primarily caters to soccer (NASL/MLS) with other uses would be nice connected to some sort of water feature (large pond/lake, or river walk). I have recently talked to a Railhawks employee who said, "We would jump at the chance to relocate to Raleigh".
One can dream.. but the talk and backing from citizens needs to start.