I am not familiar with the Cayman but on the Boxster when you open door the window drops a bit and then re-closes. Does your's do this?? If it does then the motor is likely ok. If not, time to take the door card out and investigate. Rare but the actuator motor can go bad.
Mike
Mike