I have been nightstopping for most of my flying days and I would not have changed it. My most enjoyable night stops were when I was flying corporate and having a few days downtime in a nice city was great.
I am now back in the airline world and 24hrs anywhere is simply not long enough. By the time I hear the wake up call, I barely feel that I have arrived.