No, it won't affect ball motion.
The CG is only going to come into play when trying to get the ball to fall within USBC's static weight requirements.
As others have said, having a CG shift may or may not be suitable for RH or LH bowlers.
To over simplify it, look for a CG shift that is opposite your handedness - left CG shift for right handers and vice versa. This is usually because the MB is placed in a "strong" position (right of thumb for RH, and left for LH), and a CG more than an inch or "so" from grip center may need a weight hole to make the ball USBC legal.
Of course, extreme CG shifts can be very difficult to drill depending on the top weight of the ball and the desired layout and reaction, and extreme shifts will usually be labeled 2nds or blems.
** Note: I may or may not know what I'm talking about. I'm not a ball driller, but I play one in my garage!