In a lot of cities where train/subway closes at night they have express bus service that take you from 1 part of the city to another and then you can take taxi from there. So with a properly planned public transport system it should not cost you $100 nor would you need to wait 6 hours.