Most importantly can you sneak attack with it?
The repeating Roman design had 2 flaws:
-wasn't as powerful
-Too accurate, which is actually bad as it was wanted as an Area of Effect machine-gun style effect. No use hitting same target 3 or 4 times.
Saw a working recreation of them in a documentary, pretty amazing
however, since it's D&D, and magic and maybe cultures who's tech advances in their own bailiwicks are far ahead of ours...who knows, maybe they solved the problem?
(always note, other universes/peoples may have tech BETTER than ours, even if in more simpler areas, like weapons/armour: 10,000 years of trial and error, plus magic, plus different mental abilities/outlooks could have huge difference)
I might consider counting the ballista in your "xp budget" if you went around adventuring with one and used it in an encounter; either adding in extra monsters or taking away a small amount of XP used.
I'm not 100% sure I'd do this, but if it seems that the ballista might be too powerful this would be a way to balance it out.

(Dungeons & Dragons)
Rulebook featuring "high magic" options, including a host of new spells.