According to rome2rio.com, you can take a train from Albany, NY to Buffalo, NY. But to get from Albany to Wellsville, NY, you'd have to take a train to Buffalo, connecting service to Mt. Morris, and then still drive a car an hour and a half to get to Wellsville.
To get from Albany to where I live in NY, I would have to take three once-a-day regional buses, and still drive a car 30 minutes.
I think the challenge for a "local-only" expedition is where one county ends and the other begins, and the local bus service may not necessarily serve a convenient point to transfer in-between.
From a US/Canadian perspective, that is incredible value. A one-way bus trip between Vancouver and Seattle costs CAD 26, which is just about the same price in pounds as the LON-EDI trip, but the distance is less than half.
A roughly equivalent bus trip for me would be Vancouver to Calgary, for which the bus ticket costs $170 / £105.
In this case, there are trains from Edinburgh to London at least twice an hour through the day, taking half the time and with much more legroom, better seats, a fairly spacious toilet, probably someone selling drinks and snacks from a trolley or bar counter, tables between seats, no road noise or pollution (it's electric), and a view.
Just goes to show how poorly thought out transit is in North America.