On the signature of the hydrophobic effect at a single molecule level