As the sun sets over the peninsula of Red Hook, the streets become dark and desolate, making it hard to envision what this quiet waterfront community would look like if filled with an endless flow of motorists.