Somewhere in-between works best for me. Much of my tractor usage involves open field mowing in the summer time. Doing that on an open-station tractor is almost unbearable. My first tractor was a 1951 Ford 8n (which I still have), and I remember some pain and sunburns from the days I used that for that task. My second tractor was a 1982 Ford 2000 that came with a big fiberglass ROPS canopy. That canopy completely took care of the sunburn issue, and it was always comfortable sitting in the shade under that canopy, and light breeze from the tractor's motion, no matter how hot that old summer sun got. The only trouble was when I used that tractor in the woods, I had to be careful with overhead clearance, and it would not fit in a standard 7 ft garage door.
My current tractor (John Deere 4120) came with a fold-down ROPS. I made a large, light-weight canopy that attaches to that, using a wood frame and canvas cover. I can lift it with one hand, and put it on or off in less than 5 minutes. It actually shades better than the old Ford factory canopy did, and I can easily remove it when I want to use the tractor in the woods. I also take it off for the winter (I use the tractor and loader and rear blade for snow removal then). With the ROPS folded down, it easily fits in a standard garage door, so I can clear the entries for our road vehicles).
If I made my living with my tractor, I would opt for a cab. I make mine mostly in an air-conditioned office however, so you could not pay me to get a cab on my tractor. I relish my time away from work outdoors (so long as I am not getting sunburned). I also love the open-station tractor in the winter time for clearing snow. Unlimited visibility, and not needing to keep windows scraped and clear is great. I am always plenty warm in my insulated coveralls, heavy mittens, face mask and wool hat. A snow blower probably wouldn't be so great, but a rear blade and front loader combo works good for clearing heavy or light snow.