I think its going to be pretty spectacular overall. You mention the display overlays etc as having to be redone along with phasers and other digital effects, which is a good thing, but actually most of the flybys and other areas were done as models and so look fantastic as they have been restored straight from the original film (unlike a lot of recent series where they only have used CGI and it really shows when put into HD). Character effects should look pretty good too; I'm not expecting miracles from seasons 1 & 2 as you mention they were quite weak anyway (getting into it), but seasons 3 onwards get better and better with only a few rough episodes each. By season 5/6 they had really got their shiz together on effects too.
The thing I am most curious to see is if they will tweak Geordie's eyes so you don't see his contact lenses

And Deanna Troi
