Not really sure what this will add to PC players who had high rez textures and mods using the SKSE which the console players won't be able to use. It's free on the PC though so why not. Will be quite the improvement for folks on the consoles though.
I believe the game will be 64-bit now. Which means no more 4GB RAM limitation. That in itself is pretty huge for the mod community. No more messing around with ENBoost to find a workaround. Also having a base visual boost will probably be a good thing for mods as well. Not to mention you will get the remastered version for free if you already own Skyrim + all the DLC.