For one thing, the same fact remains that 99% of the time there's nothing to see under water. Divers have goggles to SEE WHERE THEY ARE GOING; as someone who has actually been scuba diving a number of times, I can tell you in no uncertain terms there is NOTHING to see under water unless you're in extremely SHALLOW water, close enough to the sea bed to stand on it.
Naval submarines don't dive in water that shallow. At periscope depth in deep water there's nothing to see but sunlight and... well, water, and patrol depth is deep enough that the water becomes absolutely pitch black. Most sailors I know find a much more welcome diversion in a Playstation 3 and never quite notice the lack of windows (which, in any case, would compromise the structural integrity of the boat).
Absolutely correct. I'm a diver as well, and I've had the (rather amazing) opportunity to go on a small submersible (with a big acrylic dome viewport) as well, going deeper than an unassisted diver normally can go (unless you're dealing with some pretty advanced hardware and pretty unusual breathing mixtures). I've never been on a military sub, except when docked, but I have gotten a walkthrough of an L.A. class, and my boss is a submarine veteran (and a 6'6" tall one... poor guy!

) and we talk about this all the time (me being an Army guy, we get to share different perspectives on lots of issues!)
Here's the reality. You get down to about 100' deep and you're on the edge of where you can practically see. 200' down, and you're almost blind except for your own light sources. And those light sources don't carry very far, in any case, as you go lower... sediment and so forth gets more dense with depth as a rule, so you're a good 50-foot viewing distance is realy about as good as you can do.
Hell, don't take my word for it, check it out for yourself. Go to your local swimming pool, put on a pair of goggles, and go to one end. Look towards the other end of the pool. How well can you see down there? And that's almost certainly "cleaner" water than you have in the ocean... albeit there may be a slight yellow tint to the water if it's a public pool open to kiddies.
Reality is that vision is almost useless beyond about 50', best case, when underwater. Submarine vessels don't operate by "vision," they operate by either sonar, or by surfacing and using vision ABOVE WATER.
And if you go by NuTrek, the view from a window at warp speeds isn't exactly picturesque; it's actually quite horrific.
Technically, if you go by "Star Trek" there's nothing but regular stars, moving fast. And, given the "real light conditions" in space, you wouldn't be able to see anything unless you turn out the lights inside first.
If you go by TMP-era rules, same thing, except for the moment you go to warp or come out of warp.
If you go by TNG-era rules, you have colorful streaky-stars. I guess you might call that "picturesque," and I'm sure is why the TNG-era ships have so many windows. Perhaps that's due to the different warp-drive system used in TNG-time (going along with the recalibrated WF scale).
If you go by nuTrek rules... well, I'm not sure that there ARE any "nuTrek rules" per-se... certainly there are no indications that there's any form of logic to nuTrek Warp drive, and in any case it's totally unlike what we've seen in the past. nuTrek really uses the Star Wars "Hyperspace" propulsion system, it seems... where you can "revert to real space" into the middle of a wreckage field without having any indication up til that point that it's there (unlike all prior Trek where you were fully aware of what you were flying towards when at FTL speed at all times).
Interestingly, JJ's "warp drive" even LOOKS like Star Wars' "hyperspace," and acts exactly like Star Wars' "hyperspace." Which, ultimately, isn't much of a surprise, I suppose.