It really depends on the quality of the coilovers you choose and how they interact with the other suspension parts on your car.
I have AST 4100's with Swift Springs on my E92 and they are 100% noise free. My car's handling went from feeling sloppy and not particularly comfortable to sharp and planted with absolutely no sacrifice in ride comfort. In fact, I actually feel the ride's improved.
E92 335i 6MT | Balloon White | Black Dakota Leather - Sold
PROcede Rev3 V5 | AE Quad Exhaust | BMW Performance Short Shift Kit | Gunmetal 19" M3 GTS Wheels | BF Goodrich g-Force T/A KDW 2 | AST 4100 Coilovers | Swift Springs F:280 R:560 | ER Charge Pipe | Tial Blue BOV | VRSF 3" Downpipes | VRSF 7" Intercooler