better off with a...?
 

better off with a lower or higher rms wattage for subs

Higher... only if you're powering it with a close RMS-wattage amplifier. A lot depends on what the actual products are and wiring, not just asking a vague question.

1000w sub on 500w power = not great.

Vague questions get a vague answer...