I think it depends on whether or not you like the color of the LEDs. Find the LEDs you are going to use and check out their color for yourself.
Personally, I have clear buttons on my bartop and I think they look great. I think the clear buttons probably look better than the color ones when they are unlit (but I don't actually have color buttons).