No offense, but I'd say we're all pretty spoiled as entertainment consumers if we consider upscaled dvd-quality video "borderline unwatchable".
Exactly! I've been re-watching DS9 lately, and my BD player seemed to do a pretty good upscaling job. It didn't look bad at all, definitely much better than the old VHS tapes I bought for a lot of money when they came out back then.
I simply cannot and will not pay a shitload of money just to have all my Trek stuff on BD. I bought Enterprise when it was cheap at Amazon, but I wasn't that impressed. I fact, I was pretty annoyed about that "commercial break syndrome" I mentioned early in this thread (I believe).
I didn't buy TNG because I refuse to watch any Star Trek with redone special effects, I'd rather have the original effects upscaled.
And I didn't buy TOS for the same reason, although you might be able to watch the original version via seamless branching, but I was told that there were some screwups with that and I think the TOS DVDs look good enough for me.
It is known that the Enterprise Bluray transfer is barely a step up from the dvd release, specially the first three seasons. In fact, when I play one after the other I barely notice a difference. Even on Trekcore's comparison videos it's hard to notice (though it's there and, of course, if you have a huge TV or a projector, you will notice the difference quite quickly).
CBS just rescanned the master tapes or whatever, and upscalled effects shots.
They didn't re-edit and recompose the show, as they did with TNG (and TOS too, I believe)
TNG BD are a huge upgrade, and should be the term of comparison.
DS9 DVD don't look that bad, especially the later seasons, though having rewatched Emissary yesterday, I can safely say it looked goddamned horrible, as does the rest of the first season.
In any case, even the last seasons look bad when compared to the TNG BD.
It's like night and day.
Also, I think you're being unfair to the project, being unwilling to buy TNG BD because they redid some effects.
They had to, some elements simply couldn't be found or would look like crap when upscalled.
TOS, yes, I think they went a little too far in some cases, but, as you said, you can still watch the originals effects.
And in case, the live action footage looks much better than the old DVDs.
But TNG? They were quite conservative, and did what they had to, essentially.