Agreed. I watched it on Netflix and none of the effects ever felt out of place. The situation here is, of course, quite different, since the TNG vfx shots never existed as anything else than SD video, just like the rest of the assembled show, so they received the same treatment as the non-vfx shots by being upgraded to HD and the original shots are preserved in the best quality they ever existed in on DVD.
The situation is quite different for TOS though, where the VFX shots were composited optically on film before being telecined for broadcasting and the new CGI shots in the remastered versions look terribly out of place, so I find the version with the original VFX much more pleasant to watch. But, luckily, on BD you can choose which version to watch, so no problem there either.