All other things being equal a forward CG (but of course inside the allowable CG range) will give slightly more pleasant handling characteristics than an aft one as the stability in pitch and yaw will be slightly increased.
It follows that if you want to increase manoeuvrabilty (what max pitch and yaw rates you can generate) at the expense of handling characteristics you will opt for an aft CG.
Remember stability always resists any manoeuvring asked for by the pilot, but reduced stability can result in pilot overcontrol tendencies.