There are some great bridges in this thread, but I'm biased to Cleveland's - in 1996, eight of the bridges were given lighting treatments by Dealessi. Here's a link to the full list with pics:
http://www.dealessi.com/civic/cleveland.html
Photo by me:
Photo by ColDayMan: