Question: are most molecular compounds soluble in water?
Answer: The larger the molecule the more van der Waals attractions are possible - and those will also need more energy to break. Most molecular substances are insoluble (or only very sparingly soluble) in water. Those which do dissolve often react with the water, or else are capable of forming hydrogen bonds with the water.