Get new headlights (the housings) from ebay and also get the HIDs from ebay, they have'em mad cheap and some offer a 1 or 2 year warranty on them. You can buy HIDs for as low as $45 so it's up to you, and since you want brightness, the temperature with the most lumen output would be an H4 (bulb type for civic) and a 6000 or 6k temp. It's the brightest, the 8000 or 8k are more to the blue-ish spectrum.
s**t, for $100 you can get H4 6k for the headlights and H3 3k for ur fogs and you'll be able to see anything at night. A retrofit is nice but its a hastle to make compared to just plug'n play from the HIDs