Reds are going to appear to fade faster than other paint colors. This is because oxidation is a blueish whiter color (modern clearcoat paint doesn't really fade that much at all and single stage enamals can be buffed to remove the top layer of faded paint). Red doesn't seem to usually show dust, pollen, dirt, etc very well. Bird crap is about the only thing you see right away on red.
Black and other similar colors (navy, deep purple colors, etc) are going to be difficult to take care of because it's so easy to see every little scratch on them. Dusts, pollen, and dirt are also going to be very obvious on a color like this.
White doesn't show scratches as well, or dust or pollen and when it oxidizes few people will notice. That is, until the car becomes an over all "frosty" look and completely loses it's shine. As with other paints, remove the oxidation and it can be like new though.
I'd personally look at other cars on the road. Really just look at the paint. Some of the best paint colors I've seen on Civics actually come from SUVs and trucks. Now remember that on a big boxy truck the color won't reflect in the same exact manner as it would on your more round car.
I wouldn't go for something too flashy (bright yellow or green for example). Muted colors are some of my favorites right now.
Other than that, the only way that paint is going to continue to look new is if you take care of it. Wash it weekly or so, keep bird crap off of it (it etches the clear and will stay visible without repair). Polish and wax it, and maybe even glaze, etc every few months to keep a protective layer on it and to make the paint look deep again. Don't wash with dishsoap and use a car shampoo instead.
This should keep your paint looking new and clean. There is an extent to that (drive down a dirt road and it won't look as clean usually) but keeping a nice layer of wax on it will actually make it less likely for your car to get scratches.