You're on the right track, anyone 90HZ or below shouldn't really consider 1000HZ unless it's what they're really used to already or they have a strange setup like 1600P or 4K settings. When you get to 120HZ+ on your MONITOR when you're at least at 1920X1080, then you should consider trying 1000HZ for awhile and see if it feels better since your monitor/CPU/GPU/RAM can report enough actions per second to your monitor, sometimes the movement will feel better at this point, still mostly preference.
Same as above
165 HZ (usually overclocked monitors):
If the monitor is "overclocked" to 165 HZ, doing 1000HZ polling rate on your mouse can get some weird jittery issues and probably shouldn't be used.
165HZ not overclocked:
Very rare only couple of monitors at 165HZ that are not overclocked, at this point everyone at this HZ should be trying 1000HZ polling rate for a good while to see the outcome, especially if running mouse 800 DPI or lower.
This is when you definitely should use 1000 HZ if at 1920X1080, at 240HZ your monitor can easily send enough actions per second to your hardware to report back quick enough on what's being tracked on the screen, one side note tho if you're not even getting close to 240 FPS on the game you're playing it can make the mouse jitter quite abit, still not as much as lower HZ monitors. Also, against popular belief/myth, you don't actually have to hit 240 FPS with a 240 HZ monitor to benefit from 100% of the monitor, more HZ your monitor still helps reduce input lag on your mouse and keyboard no matter if you're hitting that FPS cap, of course hitting that perfect 240 FPS tho is key, and if you're hitting at least 180-200 consistent frames in your games definitely should practice with 1000HZ polling rate, trying it game by game to see how it feels.