With a plane, I leave at 10:00 in the morning, arrive at say 14:00 in the other city and check into a hotel at 15:00.
With a train, I leave at 22:00 in the evening before, arrive at say 10:00 in the other city and check into a hotel at 15:00.
Same amount of hotel stays. A few more hours in the other city. But since I have to carry around my luggage and don't have a shower and toilet, I am not sure if those hours are a plus or a minus.
For city travel, I've had good experiences with hotels that let me check in early (before noon). I've never had a hotel that wouldn't let me stash my luggage before check-in.
Basically spending 2 out of 3 nights in hotels due to the night train (compared to if we'd done the same itinerary but with daytime trains).
Train stations in Germany at least generally have luggage lockers, so you can just leave your stuff there. It's not hassle free, of course, but pretty convenient. Not sure if that's common in other countries.
Night trains really are the closest to teleportation that humans have come up with yet.
Even with your example, you're getting an extra day in your destination without an extra hotel stay.