Sounds like a very typical problem I've encountered with Nvidia drivers and older CPUs.
Have you checked the "Threading Optimization" setting in the Nvidia Control Panel? If you're on an older CPU, try setting it to "Off" rather than leaving it on "On" or "Auto".
With it enabled, on my old Core 2 Quad I always had massive CPU load even with VSync on.