I, too, believe downtown Raleigh has enormous potential and that potential will be realized within the next 10 years. (at least I hope so since I'm about to close on a condo downtown ) The area around the new convention center should really be an entertainment hub in the coming years. I think a theater would do nicely there, along with a more diverse selection of restaurants.
On GloSo...I agree about it being a yuppie haven, but for only being 5 or so years old, its doing damn well for itself. I think it will only get better. City Market will need to land a big time tenant for the former Greenshield's space to maintain its status downtown. I really hope some big building are built in the CBD to provide a visual stature to the city along with street level stuff for dining/entertaining. Here's to the next 10 years!