The only "change" I want is correcting the phaser mistake in Darmok. Any other change would be akin to pulling a George Lucas, and would be a disservice to the show.
I agree, adding a modern day polish to the show like CBS D did for Season 1 I'm all for but totally re-imagining effects work goes against what they're trying to achieve.
I'd like to see minor improvements, one that comes to mind is the shot of the Borg cube beginning to self destruct as the Enterprise moves away. Reusing the antimatter spread explosions didn't look terribly convincing.