Things would be very different for a hit in really deep oceanic water, where an appreciable part of the depth of the transient crater would be in water rather than rock. In such cases even a fairly large bolide might not even leave a discernable crater on the bottom.