Actually quieter than 4 cyl. Camrys I've driven from '96 to the present, latest '01 (the RAV4 V6, I'm talking about - quieter than the I4 engine, especially cruising at highway speeds). This is also with the stock Geolandar tires. I recently put Pirelli A/Ts on (235/65/17, fits and handles fine), and they give me a little more sound and feel feedback from the road texture, but not bad at all.
If the I4 sound bothers you, try the V6 (maybe not the very best reason to like or dislike a car, but there it is, and the engine DOES make a difference).
Overall, I'm VERY pleased with the low level of noise, but someone who's used to a Lexus or other luxury car may not be.
Let us know how you like the test drive!