A former high-ranking police officer in Wales has been dismissed for "inappropriate and misogynistic behaviour" towards ...