I've not been able to get on here much as we've been relocated for the last few months, but it's nice to see more and more people embracing the Cayenne for overland and offload duties.
As for tires, we started off with 265/70-17 (31.6") general Grabber AT/2's which lasted a good 45-50k miles. We've now switched to the new General Grabber X3's in 255/75-17 (32"). These are technically MT designated, but they were designed to reduce NVH, etc. I don't think they are any louder than the AT/2's were. I was worried about rubbing but decided to go for it. The AT/2's rubbed slightly at full lock when new. The X3's never rubbed at all. This is due to the fact that, though they are a bit larger over all diameter, they are also slightly narrower. So, at least in Grabber X3's, 255/75-17 is a 32" tire that will not rub with factory suspension geometry/height.
I will say this, and for some it will be very important. If you've not changed tire diameter on a truck before, know that it will have a large impact on acceleration/response/etc. I have a 6 cylinder which I'm happy with. I bought the Cayenne specifically to convert to an overland vehicle and it's fine for that. Changing to the 32" over all diameter has had a substantial effect on acceleration and response. The Cayenne needs to downshift more frequently and on less steep of inclines than with the stock tires. This doesn't bother me but for some it may get annoying. Also, when I bought the Cayenne it felt like I was driving a large, well performing car. It now feels, firmly, like a truck. That's not to say it's bad, just know what you're getting in to.
Having said all of that, I towed my 944 from Houston TX to Little Rock AR with my Cayenne equipped with the X3's. Total towed weight was around 4,500 lbs. The cayenne needed to downshift for most every hill but had no issues and was perfectly happy.
I apologize, as this is getting a bit long, but I want to say a few things about reliability. Many people have brought up reliability regarding the Cayenne. My advice is this. If you've worked on vehicles quite a bit and are willing to continue to do so with the Cayenne then don't hesitate to buy one. You will need a few special tools here and there but it's not difficult at all. If you take your vehicles to the dealer for every issue, do not get one. All vehicles wear and eventually things need to be replaced. Porsche charges very, very high prices for any service.
If you plan to work on it yourself you will be fine. Reliability/failure wise, I've done the following.
-Oil/filter change
-transmission fluid/filter change (requires Durametric to read a/t temp, weird process but not hard)
-engine air filter
-cabin air filter
-HVAC blower motor (failed around 110k miles)
-ignition coils (failed around 90k miles)
-spark plugs
-accesory belt
-Drive shaft (center bearing support failed around 100k miles)
-misc bulbs
I think that's about it. I'm now over 150K miles and rocking along fine. Most of the big failures I had all occurred around 100k miles. Nothing major for the last 40k or so.
I've posted about my Cayenne on page 42 of this thread. I realized the picture links had broken so I fixed them. We're in the process of making some large changes in preparation for our next trip (Badlands/Black Hills) in May/June. When those are complete I'll post about them with more pics on here.