Trying to find ways to motivate people to stay active and involved is a significant challenge.
The Pacific Soaring Council has a number of awards that you could replicate for your state or region.
https://www.pacificsoaring.org/awards/awards.html
Fair warning, I don't think these produce a lot of motivation. If it wasn't for Ramy doing all of the OLC analysis, I'm not sure too many people would even notice if they disappeared.
We also had to modify the rules. Basically Ramy's fault. Some awards have limits on how many times they can be won. Otherwise it's just the Ramy show at awards time. Total distance awards skew towards people with the skills and time available to fly long distances and lots of days.
Our club has a number of fun annual awards which are great for a good end of season presentation and light ribbing at the local level.
Good luck,
Morgan