For vanilla Skyrim, I'd say it's more on the CPU intensive side, but in your case for mods, I think you're better off upgrading your GPU. Your CPU is still more than sufficient, but you might run into some GPU bottlenecks with visual overhauls.