My one and only sleeper train experience involved being woken up at 3am by police with guns to check passports. Never again.
Second best might be Portland, OR to Sacramento, though I might have liked it if had been more like travelling to the past (I miss proper dining cars).
European ones have been cheap, cheerful, and uncomfortable, but this was 15 years ago for trips like Florence to Prague, IIRC.
I think when you share anecdotes like yours, its good to share anecdotes like mine, to balance it out :)
Added: GP is probably talking about a train that didn't cross a border.
This was like two years ago or so, so still exists probably