It really depends, my company is moving to a more point to point network operation and that will mean fewer nightstops. However, a few will still happen and especially those that have to shuttle because they do not live near their base (especially now that 5 bases have been closed) will try to get those as it means less self paid hotel stays for them.
Personally i can live without any nightstops and did very happily so for a few years in the past. But i do enjoy the odd 36 hour layover in a nice city, particularly enjoy stockholm and copenhagen, would love to get a budapest one as i haven't visited the town yet. Would dread moscow, but love st. petersburg. Nightstops are a normal part of non-lcc airline life, some like them more than others, but a few a month (not more than 5) are usually nice, depending on the crew of course.
Even on our longhaul fleet it is now usually minimum rest and then back home, which means that there isn't much time to explore those destinations.