If the technology improves they'll find a way to do it cheaper, I'm sure. Though I don't really care about TNG-remastered. Only if they added some cool new CGI END-D interiors. I don't know how they'd do that exactly, but I would like to see some of the more exotic locations. SB-1, the larger holodecks, the big labs, the big lounges, all the stuff they couldn't do on a TV budget in the early 90's.
I'm fine with TNG's effects pretty much as they are. If they do a TNG-R, all I would really ask is that they get rid of the overused stock footage, such as the same matte paintings showing up as all those different planetary backgrounds, and the stock footage of an Excelsior
-class ship every time another vessel is shown with the Enterprise
I admit I'd also like to see what the main shuttlebay (which we never saw) looks like.