Are you running HID's? Yes it will be a huge upgrade. I don't have CCFL projects but I do have retrofits and I'm running 6000k HID's and 2500k halogens and it looks amazing. If you run 3000k HID fog lights it won't be as yellow when you stare at it but it aims out looking yellow. Don't get eBay ballasts. Find some decent HID kits. DDM tuning has really good ones.
I don't find any point running HID fogs so I don't but I know people that do and it gives a bright output. Not sure what bulb size your CCFL's are but mine are D2S since they're from TSX. As for the fog lights, the direct fit is H3c or H3 and you won't need clips but you will need an adapter for H3 unless your running HID's, then you'll have to mount your ballast.
Here's a pic of my Prelude running 6000k HID and 2500k Nokya Halogens.
Here's my buddy's Civic running all HID's (Fogs, Low beam, High beam)