The sweet spot absolutely exists. When I went to school in DC, and wanted to go home to north NJ, taking Amtrak was about the same cost as a flight, about the same time (because of airport overhead, and because the airport was further away than the train station), and more comfortable.