Redcar British Steel when I went will take some beating!
Just after the steelworks had stopped production. It was dark, an extremely windy night. Got off the pacer and the guard made sure I knew there wasn't a train until Monday before departing.
Being stood at this totally barren platform, surrounded by the steelworks which were all still lit up but totally silent apart from the howling wind.
Pilning and St. Andrews Road I'd certainly agree with. As I would for Carstairs waiting for the sleeper.
Reston... yeah. Not much there that's for sure. I'd imagine on a winter's night or in poor weather that wouldn't be somewhere you'd want to be!
Carstairs, early in the morning in winter felt pretty bleak. There was a Manchester-Glasgow Voyager which stopped there and dropped off passengers for Edinburgh, then a Glasgow-King’s Cross service rattled through without stopping, then a Pendolino empty from Polmadie arrived for us to Edinburgh. The Pendolino then formed a service to Euston.
This was a few years ago, mind.
Still happens, however it's a TPE service heading North that calls, almost certainly the same path. The connection is a Glasgow-Edinburgh ScotRail now, though I think CrossCountry will sometimes call if the connection is missed or cancelled.