I've used both for SystemC and System Verilog/VMM for verification, and the answer is, it depends. When I was with a startup that was on a shoestring budget trying to get their first ASIC out the door, SystemC was a natural choice because it ran on our low-budget simulator and SystemVerilog did not. With SystemC, you don't need to use the PLI or the DPI. You actually instantiate your SystemC model as a component in your testbench, which is interesting.
However, SystemC is a C++ library that does NOT have a very intuitive syntax. You should have a decent C++ background before attempting to learn the SystemC library. The books for this that are available mostly suck, except for "SystemC from the Ground Up" by David Black.
That begin said, from what I've seen, SystemC is naturally a high-level modeling language, not a verification language, and nobody with any budget to buy real simulators is using SystemC for verification anymore. From a general career development standpoint, I would use System Verilog if it is available to you. Plus, you can always use the DPI to interface to your C model for output checking, which still using generators, monitors and scoreboards written in SV/VMM.