Suggest you drive them both before deciding. I faced the exact same dilemma and after a good drive of both elected for the Cayman S as I felt it suited my driving style more than the 997.
997 everytime - Cayman is great, but lacks character in comparison. Cayman is probably more competent at what it does, is easier to drive - but the 997 just feels like a more serious car.