I also use my Q for city driving... no "serious" off-roading since owning it.
I got my tires from CostCo

Without running out to the rig to confirm, I believe I have these:
http://www.tirerack.com/tires/tires.jsp ... oModel=QX4
All I know is that they were called "Michelin Latitude" by the tire installer. Not sure if there are different types of Latitude model or not.
I don't experience very noisy road-noise, but on the same note - I am not very sensitive to road noise. I guess one way to measure this is that I can still hold a conversation with the back seat passengers just as well as most other early model cars (*early model implies that the newer cars today have cabin noise reducers and such).
and since they are CostCo purchased tires, they are guaranteed to last you at least 5years, or CostCo will prorate you the time of premature wear.
For example, if you purchased a single tire for $200 and for whatever reason they wore down (under normal use of course

) to 2/32" within 2.5years (2.5 for easier math

) which is 1/2 the time they guaranteed at 5years, they'd refund you $100 for the tire.