I'd love to have it as an interior for Orion ships instead of the Red Industrial Klingon interiors.. I could definitely see Shangdu as a social hub with silly mini-games(especially with the arena) and such though. Granted... I suspect Starfleet Dental would have the place on tighter lockdown than Drozana before it was given a makeover.
Personally speaking however, the revamped lowlands outside of First City on Qo'noS are simply too beautiful not to be a social hub/public zone. I would much rather see it get turned into one before Shangdu.