Question: I'm a pretty avid user of SU. However, I spend most of my time there rather than here in the meta discussions.

I would be very willing and happy to become a moderator there to help even more, but I feel that lack of 'meta activity' would hinder that chance.

This isn't a cry for me to become a moderator, but just a general question as to how one can be 'noticed' if they aren't heavy meta users?

Answer: 
Being active on SU is more likely to get you noticed than being active on MSO. There are relatively few of us that spend any real time here, and everyone gets just one vote for a moderator.
Put a beaver on your avatar.