I was traveling by night train twice a week for multiple years in early 2000s, Vienna to Bonn, Cologne and other places in Germany. If I could afford to fly, I would. It got me to the destination, but I never learned to fall into relaxing sleep - the day after the travel was always bad.
Still better than taking a bus.