Over night train ride?

You can do it on AMTRAK in the US. Based on the reviews I've seen of most of the experiences, and the cost, I'm going to pass on the US. There are a couple of interesting routes (London to Scotland, etc.) in Europe. There's a decent listing at Trainline.

Lots of great options in Europe, Asia but need more info on what you want to do. In US look at routes along West Coast and Midwest to West Coast, and definitely consider San Francisco (Sacramento) to Seatle on the Coast Starlight.

I did Paris to Munich.