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: 
Create or become a meme, it's a sure fire way.

But jokes aside, just be consistent, friendly and helpful. The main thing is that you're there, a lot. If people can think "Hey, this is a great question for X, because he helped me in the past" then you're on your way.

Another thing. Mod != High rep user. A mod is a person that can be counted on to be there and can be trusted to do their job. So having a history of being awesome helps a lot.
I hear that Jeff likes waffles.. Figure out his address and send him some waffles. Bribing is **always** the way to go