I've never seen a Switch in action so I don't know how it looks/performs. My gut reaction, however, says that it's not going to be significantly better-looking on a PC without throwing lots of mods at it - and that is where you can absolutely murder your performance in a hurry, so be careful and add mods just 1 or 2 at a time until you can gauge their impact.
It will, however, look tons better than the PS3 version...
Basically, I'd suggest staying away from too many "make it prettier" mods and instead focus on the mods to improve gameplay, especially if you've only ever experienced it vanilla, without all the glorious things to make it mechanically better.