Every time your mouse sends input, your CPU processes it, so the better your CPU, the higher polling rate it can usually handle without issues.
Using 1000Hz or lower isn’t bad, but it might put you at a slight disadvantage in TeamFortress 2 or other fast-paced games.
This video breaks it down really well:
https://www.youtube.com/watch?v=jtATbpMqbL4&ab_channel=optimum
I’ve used a Razer DeathAdder V3 Pro with the HyperPolling dongle (goes up to 8000Hz), and now I’m using the HSK Pro 4K (which, as the name suggests, supports 4000Hz). In my experience, 2000Hz feels like the sweet spot being both fast and stable with no performance hits on my 9950X3D.
If your PC can handel higher rates just fine, there’s no harm in cranking it up. Even a tiny bump in response time is technically an advantage.