My advice with every game is to play it for a while in vanilla first. You will only know what to change with mods after you get the chance to experience it for yourself.
However you did imply you've had the console version so in that case ignore my advice and download whatever mod you want.
Also for future reference, Steam rarely changes the file structure of a game too much so mods aren't usually an issue. In fact steam has a workshop to download mods with the click of a button. The nexus has arguably better mods but you risk messing up your files.
Lastly if you buy the PC version with DLC before the 28th you get the remastered version free. I personally will be using that version from then on.