It could be related to this issue: https://github.com/ValveSoftware/steam-for-linux/issues/9805
Edit: Might be an issue with a recent libgudev update. The end of this comment has some potential work arounds: https://github.com/ValveSoftware/steam-for-linux/issues/9805#issuecomment-1626486059
If you still have the G500 (or anyone else who has the double click issue), you can try taking it apart and cleaning it. Mine started to do the same thing about 6 months ago. I followed this guide to clean the metal contacts: https://zalbee.intricus.net/2014/02/how-i-fixed-my-logitech-g500-mouse/
I didn't do step 4 to remove the leaf spring and followed the advice in the Warning section in step 3 instead. It surprisingly worked and I'm still using my G500 now without any double clicks since.