After decades of disinvestment in Brooklyn , major projects are in the works , among them the development of 175 waterfront blocks , complete with 40-story luxury apartment buildings , along the Greenpoint-Williamsburg waterfront ; the construction of an 800,000-square-foot sports complex for the Nets in the Atlantic Yards ; and , in Red Hook , the return of cruise ships , including the Queen Mary 2 and the Queen Elizabeth 2 , to a major new pier and passenger terminal .