the improvement over standard handling is huge. if you buy fully adjustable coilies you can adjust the damping and have it as stiff as you like (oo-er missus)
some people find coilovers a little too harsh even on the softest setting and opt for the basic lowered spring/uprated dampers setup instead, which is not only cheaper but gives a softer ride depending on the shocks you buy.