Brownfield sites are transforming. Thanks to innovative programs, neglected spaces are now becoming vibrant community hubs of pride.