So overall, it shouldn't do much either way, aside from make a little more noise.
I like noise. My wife probably won't care much, but who knows, she loves telling people she has a diesel and seeing the confused look on their faces.
And yeah, it does make that noise, but oh so quietly, with the stock airbox. Hearing it more would be neat, assuming it's not detrimental to the vehicle's performance/fuel economy. Obviously, the stock air box isn't exactly restrictive to begin with.