For security it's worthless, but for reducing log noise it's not a bad idea if your number of users is low.
If you only have {2fa,key,certificate} auth the number of alerts you should have from SSHD itself is (almost) zero, failed logins are (almost) _all_ _noise_. Higher level systems that monitor origin/destination/heuristics of successful logins are where its at.
I moved it to another port...0 attempts in the last 7 days (btmp was rotated then).
It shuts down log spam 100% for me.