More power will be cleaner, louder, less distortion. However, if you have a stock charging system in your car, you really won't be able to deliver 1000 unclipped watts.
People with the proper electrical upgrades and gains set conservatively can use twice the rms power with no problems. It all depends on the quality of the sub, if it is underrated, the way it is all adjusted, etc..