I'm not sure about CC, but as far CS6 goes no media decoding is handled by Mercury Engine, not even h264 or AVCHD where cards contain hardware accelerators for such tasks
Adobe don't maintain their own H.264 decoder. They use MainConcept's under license, which is a shared library and runs on the CPU. "GPU," by the way, isn't a magic word. From what I understand, some types of math are just not a good candidate for GPU processing. The math used in codecs like H.264 and REDCODE (JPEG 2000) are examples. That's why special hardware DSPs have been needed to accelerate these codecs. As an example, a typical smartphone SOC has a GPU
and a hardware H.264 decoder. Why not just use the GPU? Doesn't work that way, apparently.
As chmee explained, you're getting 1 fps because ACR (which renders DNG inside After Effects) is not accelerated and runs on the CPU. It's very high quality, and not designed for video playback. Remember, it was designed originally for still photography.
That said, an upgraded GPU will do exactly
diddly squat. If you want to speed things up, use software with a GPU-accelerated debayer engine like Davinci Resolve. Or the latest Premiere, if that even counts.
Or render your DNG files to ProRes 4444 first, then composite in AE.