Welcome to the forum, BMWBruin.
The Cayenne S is a solid SUV, but if I were to get a Cayenne, I would only get the Turbo. The Cayenne S seems to be a "jack of all trades, master of none" SUV (and there are cheaper alternatives, such as the Touareg) and the regular Cayenne (3.2L V6 from the VW Passat, mated to a 6-speed manual) is just too slow to even wear the Porsche nametag.
At least with the Cayenne Turbo, you get standard height adjustable suspension (optional on the Cayenne S, but NOBODY opts for it) working with a 450hp biturbo V8 to make it an absolute monster on and off the roads.