Say im trying to get colors like this:
Looks like the photographer boosted the midtone contrast. You can emulate that using the Unsharp Mask function in DPP or Photoshop.
BTW, if you're shooting a lot of fast action sports pictures, many sports photographers still prefer to shoot bursts of JPGs rather than raw.
You can only learn what works best for you by experimenting.