Water is a great solvent. It’s neutral and doesn’t provide any strong positive or negative effects. It just helps components to mix better and to transport active components.
Cetearyl Alcohol is used mostly for formulation purposes. It’s a very good emulsifier and emulsion stabilizer. It helps the ingredients mix better and it makes the product spread on your skin evenly. It also makes the product thicker. It doesn’t belong to harmful alcohols and it will not dry your skin.
Fragrance is a mix of chemical ingredients (usually 20-30 chemicals but up to 200 sometimes) that help the product to smell better. It can hide many bad things. Synthetic fragrances may contain many different chemicals, but manufacturers don’t want to reveal each of them for some reason and hide them behind the word "Fragrance".
Chemical fragrances can lead to irritation or cause allergic reactions. Fortunately, the fragrance is usually located at the bottom of the list meaning its concentration is low. If you see it at the top, it’s a bad sign… It's a good idea to test the product first in this case.