Most any lowering springs are going to make the ride a little rougher, some more than others. Anything labeled "race" or anything that drops the car more than 1.5" is going to be rough. Aim for springs that will lower your car .75"-1.25" or so, when you go lower than that, you're bound to have tire rubbing somewhere.
Keep in mind progressive rate springs offer a more comfortable ride than specific rate springs.
Also, good shocks and struts are key in making the ride more comfortable with lowering springs. Leaving worn out stock stuff in there will make the ride bouncy and rough.
I would avoid cutting springs. There are guys out there who make it work, but it's usually considered "bad practice".
Finally, after you install the lowering springs, be sure to get an alignment!
EDIT: My car has FRPP "B" springs. You can see the stance in my sig.