Hey, if you're upgrading your tires go from the original wobble sized 175/65-14s to the sportier 185/60-14 or if you feel spendy go with the 195/55-14s, you'll notice the difference in handling but you'll also notice the bumps more.
Most brands have different handling in different conditions, most performance tires handle great in dry conditions, some handle like crap in the rain, some handle like crap all the time, some are good in rain/snow, etc. It depends on brand really, I found the Kumho 711s that I had were pretty good rain or dry for the money that I paid for them, but most of the performance oriented guys think they don't handle as good as they could on dry.
I also have a set of Michelins XGT-V currently on my car and they're OK on dry, but god forbid someone spit on the road cause they handle like shit!