Completely naïve guess, but maybe it'd make sense to tap into the hip muscles to hint the controller system what you want the tail to do. In zero g, a slight rotation in the pelvis won't cause too much movement, but I think it would feel fairly natural to trigger a tail swing with a hip motion.
I think the tail attached to the back might be physically awkward or impractical. After all, there's probably a good reason that all animals with prehensile tails have it attached to the pelvis. But then again, it may just be an artifact of it being an extended spine.
Unironically, I think this is a fantastic idea that might actually catch on if/when humans start spending extended time in zero g environments. Tails do have a lot of advantages for navigating and manipulating 3D space.
Unfortunately, I don't think we'll be able to actually solve the problems with this design until we're actually in space regularly.