Well, I've heard Komodo's intake and he isn't lying when he says it roars if you floor it. It really does.
For myself on the other hand. I went with an E-Bay brand intake and the only sound differance is when your about 1/5th throttle, you can heard the valves open up and a slow "shhhhh" of air being pulled in. Then you floor it the sound goes away for the most part, you might get a little more reverberation just because there isn't a big air box to keep it all in.