The cheap-looking boots ___ to be waterproof during the storm.

Explication

Turned out introduces the final discovery that the boots really were waterproof despite appearances. Turned up would describe arrival or an increase, neither of which can express the discovered result.