A wet and windy weather system tore a wild path through southern New England on Friday, unleashing at least three tornadoes that brought nickel-size hail and winds that lifted and flipped cars, uprooted massive trees, and generated a waterspout in the ocean off Boston.