TL;DNR: It depends if you are backpacking or car camping.
I have owned several mesh tents with windowless rainflies. I have not owned any tents with a "window" (an opening to the tent not meant for ingress and egress), though I remember them from my youth. The tents I have owned would all qualify as backpacking tents, meaning they where constructed with a focus on saving weight and withstanding wind and rain.
If you see me lugging a tent around, chances are that I brought it to facilitate an extended stay in nature and I try to spend the least amount of time as possible locked away in anything with walls. If I expect a lot of rain I often bring a tarp in addition to a tent. Under the tarp I can cook and hang out. If I want fresh air during the night, I leave the rainfly-zipper of my tent open but close the mesh. I normally don't leave the rainfly off. If I don't expect rain, there is little dew and I am somewhere in the wilderness I normally don't even set up the tent.
I could imagine use-cases for tents where having a window could be nice. If you bring a tent to a picnic to provide shelter from the sun or from rain, a window might be nice to keep an eye on the little ones.
If you are planning an extended road trip and want an experience more similar to traveling by RV, a tent with windows might be nicer than a backpacking tent with a windowless rainfly.
Tents like the previous two are probably not very useful for backpacking though, since they are likely large and heavy.