I'm about the same as you I think. It'll likely vary from person to person but I haven't experience any pain or discomfort with a lighter mouse. I used an M65 (~135g) and it became kind of annoying after a while, it wasn't uncomfortable but the mass definitely made it slightly harder to play with.
I disagree, you should chose based upon comfort. It's like a steering wheel, if it feels awkward to use it's going to have a negative impact on your performance.