With acres of piers for hauling cargo , and sweeping views of the Manhattan skyline , Red Hook should have become a leading industrial port or another charming Brooklyn village like nearby Carroll Gardens .