No, it will still feel slow no matter what you do power-wise to a 2.0 auto, short of a turbo/supercharger kit. Some people actually see a slight loss of torque below 3k RPMs with many of the popular catback and CAI setups. Of course, they get them for the gains in the higher rev range and don't care about that.
As an average, sane, intelligent and mature person driving the car on the streets daily, it's definitely not worth spending any money on performance parts for pure performance reasons. The main reason to get a CAI or exhaust would be for the better engine sound and slightly better throttle response.
The HID upgrade you mentioned though, if your car only came with halogens stock, would be a great mod. They make a huge difference in visibility, and look awesome from the outside too. And there's plenty of other visual / audio / cool mods you can do to make the car better for you, which you would appreciate on a daily basis more than power mods.
