This waterspout was filmed with the Sony A7 ILCE full frame camera with the Sony 85mm 1.8 lens. It was after twilight but the lens pulled through since it I had the aperture wide open at F1.8.
The photos below were taken the the Rokinon 14mm F2.8 lens on the A7. I had the aperture wide open at F2.8 to let as much light in as possible.
This sounds a but backwards but the higher the Aperture number, the smaller the aperture gets thereby letting less light in on the sensor resulting in a darker picture with less detail.