I did not try the night trains yet, but did use regular high-speed trains to go on vacations. I have good connections to Austria, Italy, France, Netherlands, Czechia and even Denmark from the middle of Germany that I have used for various vacations. But you waste two days of your vacation for traveling to your destination and back (which you usually also have to do if you go by car or fly).