I believe the question needs to be answered for each turntable.
And of course, most importantly, cantilever compliance has to work with the arm mass. If this isn't right, you could be wasting a lot of money.
In my personal experience, although I never got there, I might have put a $250 low compliance cart on my old Pioneer PL-550. A 'table that currently sells for between $5 and $200.
I feel I reached the cartridge ceiling at around $250 with the AT150MLx on my Rega planar 2 (RB250 Incognito arm). The increased performance of the $400 ATOC9 MLII I replaced it with was lost on the Rega. (The Rega by the way has a current value around $400, but was $500 new add to that $350 in upgrades.)
The OC9 is now on my Well Tempered. This 'table now sells used for %650- $1k, but was $2,500 new. I think the OC9 is just at the bottom of "appropriate" for the Well Tempered. Most people I read about have $1,200+ carts on this 'table.
So, I guess, experience has left me with the thought that a cart costing about the same as the 'table is a good balance. But my opinion may change over time.
Of course, all this is dependent on having downstream electronics that re sensitive enough to reveal the differences in cart/table matching. I mean, if you've got a $50 phono amp, I don't think it makes sense to mount a $1,200 cartridge on a $2,000 table etc, etc.....