Just a quick heads up for anyone else performing this procedure. I just did this on my 2008 CX9.
The video at
https://www.youtube.com/watch?v=gPZrjQY0g5E is great, but a couple of notes about it:
* The video and audio aren't always totally in sync (for instance he says "there's one vent line you're going to pop off" at 0:59 as he's pointing to a clamp that needs to be loosened - the vent line was already popped off a few seconds prior at 0:55)
* Reaching a few bolts would have been easier with the battery removed (especially the one for the bracket connected to the lowest bolt on the throttle body), but I left my battery in
* The air cleaner assembly has a wire harness that needs to be pulled out with a trim tool (in the video, it's already disconnected)
* I disconnected the throttle body completely to take it out and give it a good scrub down since it was filthy - a lot easier than doing it while still in the car
* My manifold was covered in loose grime - shop vac to the rescue, before taking it apart and removing it from the vehicle
* You don't need the more expensive MS 97118 kit. Instead you can get just the upper manifold gaskets in the 97120 kit. The throttle body gasket is Fel-Pro 61466
* The hoses behind the manifold were the biggest pain - a hose clamp tool would have been useful for sure - but even still the hoses were pretty glued on and I had to slowly work them off with a flat blade screwdriver
* The wire loom across the manifold required popping off 3 different connection points with the trim tool - presumably a model year difference
* My 2008 had the wire at the rear of the intake manifold just below the first hose that's disconnected (mentioned elsewhere in this thread). Manifold wasn't coming out and I thought it was snagged, but it was just due to the wire still being connected.
I also started getting white smoke from around the engine after doing the job, which I couldn't believe as I thought I did everything very carefully! It turned out that I hadn't seated the hose from the air box correctly (I think the air box side may have shifted a bit when I reseated the hose on the throttle body). In any event, that's the clamp right next to the MAF sensor - so it was presumably causing a bad mixture into the engine. I didn't get any codes and nothing was overheating - just a simple error easily fixed. I'm not sure that clamp even needed to be loosened in the first place to be able to disconnect from the throttle body, but I was following instructions.