While most Denver buses close at 12am, the last but departing Denver airport leaves at 1:30am1, and it can get you most of the way there.
Bay Area
Edit
Bay Area Rapid Transit (BART) begins closing gates at 12am. The trains continue running until they've reached their final destinations.