In my experience it was a near perfect form of travel. Arrive at a train station long after most people had gone home, board the train and fall asleep, wake up at the platform very early the next day. You lose practically no 'useful' time.*
The one thing which stopped us making use of it more frequently was the cost. It was generally more expensive than flying, much more expensive than driving and even more so now that we have a child.
* In fairness, it's pretty loud and not massively comfortable so if you are a light sleeper you might not get the full magic carpet effect.
While I'm happy to spend a little more for the sake of the environment we're talking something like 3-5x more expensive.
Trains from Paddington to Truro run every hour, taking around 4h30m.
https://traintimes.org.uk/london/truro/09:30/today
Considering its 1/3 the distance from London to Glasgow it's quite slow, but it's still faster than driving.
It's also ideal for getting a full day of work in either London/Glasgow and returning. Doing that by plane is also possible but is environmentally horrible and taxing, doing it by train eats into good chunks of the days either side.
In the UK, experiences vary. The new Caledonian Sleeper (London-Highlands) is apparently a pretty rubbish experience. However, I took the Night Riviera (London - Cornwall) a few years ago and found it a pretty good experience even though I very nearly missed my stop in Truro. The problem for a business traveller is that you would need a shower.
The other problem facing the Caledonian sleeper is that London-Glasgow is only something like 4 hours and the day trains are very good. The same is not so true for getting out to Cornwall.