Is it better to have a high viscosity motor oil or a low viscosity motor oil?

Neither. Each has it's purpose. Use exactly what the manufacture recommends and use a multi-viscosity oil that will work in both cold and hot climates. The most common weight recommended in in new cars today is SAE 5w20.