I actually live in Oakdale, which is close to both Modesto / Stockton. It's like an hours drive to Dodge Ridge, which is where I usually get a season pass. It sucks, but it's close. Make the best of it.
I like Dodge Ridge actually. You're right though it's not great. I've had a lot of good times at Bear too.
Funny you live in Oakdale. My brother had a house there right off of 120 for a good 10 years...