I do (fondly) recall seeing those long-tubes fluorescent streetlights used on various major highways and thoroughfares when I was little. They seemed to disappear VERY quickly during the 1970's, having been replaced with the aforementioned cobra-heads. My guess is that it had to do with the energy crises of that decade, though fluorescents are really pretty efficient. My recollection is that they did an amazing job of lighting up a street or highway; far better than anything offered now.
Even cooler are the old incandescent lamps that may still exist in distant corners of the northeast (especially New England). The last ones I saw were in 2008, on residential streets in Devon, PA - just south of US 30. They offered a very pleasant and warm glow that none of the fluorescents (be they sodium or mercury) give you. All of the streetlamps around the monuments in Washington D.C. were of this variety as of at least 10 years ago (haven't been there in a while). Again, that yellowy-white glow is very nice and the way it reflected the white stone of the various monuments was just beautiful.
Never liked the pinky/orange glow of modern streetlights. Yes, they work, but the light is ugly. worse still is the orangy-yellow glow given off by streetlights in many parts of the UK and Europe. They make for a black and white world because you can't see colors very well. And, IIRC, they're not that bright either.