Kim Cattrall, fascino da "Sex and the city"