Should I soak my red and yellow potatoes in water like I do for Russets?

If this is in preparation for a dish and you anticipate some time-lapse during the process, then yes. Just remember to add a teaspoon of vinegar or citric acid to help prevent oxidation.