The ones I think of in US are NYC and LAS. Surprisingly, the bars in SDF stay open till 4am - they get a steady crowd from the uni and Fort Knox.
Question about NYC: Which specific areas most exemplify the "city that never sleeps" moniker? Certainly not Wall Street or many parts of Queens / Brooklyn. Is Times Square a 24/7 area?