CX-7 is very comfortable on long drives. The fuel economy is a bit disappointing though, and considering it requires premium fuel, should have a little more horsepower for a turbo engine. Mazda would have done well if they tuned the 2.3T to the same performance as the Mazdaspeed6 has in the same engine.
Have 85,000km on my 2009 and no issues with reliability and no major repairs needed, just regular maintenance. Very comparable to Acura/Lexus SUVs in terms of luxury and featrures for a lot less $.
The BOSE Centrepoint Stereo is amazing. Clear, crisp sound right up through the volume range.

First time we drove the Tiguan we were impressed. Very responsive with the 2.0T and handing is very tight. One of the only smaller SUVs we've sat in that has leg room in the back (feet easily slide under the front seats) and has thigh support for longer rides. Expect a little higher maintenance costs if you have it serviced at VW, but worth it for peace of mind.