All my career I have worked in 1-4 person offices with enough window space on one or two sides. When the sun comes around, close the blinds a bit.

It's possible, just not with open floor plans and cubicles.

My desk is next to a window. It has literally never been an issue, and always a pleasure.

Airconditioning, positioning and judicious use of blinds is always enough.

Agree here, I have a desk by a window (with quite lovely view frankly), but I have a blind down most time because the sun, the sun is very bright and very hot and can heat faster than the AC can cool. I even had to get the partial light blocking blind replaced with a full light blocking blind. The sun light wasn't even hitting my monitor, the orientation of everything meant it just hit me straight in the face blinding me for part of the day. I still like the window seat, but it isn't all great for sure.

Yeah, that orientation makes all of the difference. My current space has an entire wall of windows but 1) the building is oriented such that we don't get direct sunlight because our side is almost directly north facing, and 2) there are very large Oak/shade trees lining the length of the building on our side. We're fortunate and we've actually had to fight a couple of minor battles to hang onto our space.