In Rock Hill, SC .. Downtown they have had these lights up that are not too flashy, but are just right to set the mood.
I went down this last weekend and took some pictures. I tried playing with exposure times and even to get some pics of the blue lights, I used a neutral density filter. It was tough to take them and have them look right.