After less than a year, I'm ready to get rid of our 2004 Cadillac SRX. I have a very limited tolerance for problems when it comes to my wife's car, and it has already exceeded it. Our 4Runner had zero issues over 65k, our SRX has somewhere in the neighborhood of 5 dealer visits over 8 months and 10k miles. Not major issues, but annoying ones. The transfer case on early SRXs has excessive lash, and can "clunk" when transitioning on and off of the gas. Dealer acknowledged problem, but wouldn't fix because there isn't a TSB.
Radio CD changer died, then new radio didn't work with steering wheel controls, which required another new radio. Vinyl pulled loose on the sunvisor. Something loose in the front end (sway links?). Transmission takes 5 sec to go from R to D when cold ("normal"). Misfire on #3 cylinder (plugs and coil packs). While it is fun to drive, it's a PITA, and the dealer service sucks at the two I have been to. Circa 2004, GM still didn't have the quality thing totally done. Final dagger of death is the zero baggage space behind the 3rd row seat. Kids or groceries, pick one.
Anyway, I had some interested parties that wanted me to post feedback after I've had it for a while, so here ya' go. Used ones are cheap at a bit over $20k, and many of the issues were resolved by later in the 2004 model year. It is a lot of fun to drive, but that's not enough to make us keep it. It's probably no worse than the competition, I'm sure the X5 and Cayanne have their share of issues as well.
So, after some shopping, the wife and I have decided we like the Nissan Armada. It's much larger, drives well, and Japanese. Early models had issues with brakes and rattles, but they're all addressed by TSBs. We plan to buy a later one anyway. My wife was never really happy with the SRX's size, we often found ourselves really having to cram to fit our family + stuff. It doesn't handle all that well, but it sure goes quickly in a straight line.