In our MDX, you can hear the intake manifold's second stage come in at 3,600 RPM, and then you can hear the big intake cams come in at 4,400 RPM. It's a real symphony of sound. When I do drive it (it's my wife's primary car), I do rev it up and let it sing.
Our CR-V is a little less rewarding. It has Honda's "economy" VTEC system, which closes one intake valve at low speeds to save fuel, rather than giving larger valve openings at higher speeds. Once you're accelerating, there really is no change in pitch or tone or "oomph" as it rises through the rev range. It's really a low-to-midrange engine, anyway. I rarely hit 3,500 RPM in daily driving--most shifting is in the 2,500-3,200 range.