Many years ago, I walked onto my junior college golf team. Non-scholarship - play for glory. We had seven people total on the squad, and you had to field four players for a match. If someone was sick, or had to work, finding four got dicey. In both freshman and soph year, I was able to prevent my team from forfeiting a match for insufficient players. Most players shot in the mid-70s, and my pal and I shot in the high 80s - but, we prevented forfeits.
Our former home course got bulldozed and subdivided about 1975, and the golf team is getting cut next year due to the recession.
So, what about college golf? I teach at private university with Division III athletics.
I suggest you look around for smaller programs. Division III schools offer no scholarships, and NAIA schools often have a mix of partial-scholarship and non-scholarship players. Look for a program where the coach is a member of the faculty. If the coach is some guy whose main business a housepainting operation, this tends to hurt the golf program.
Also, being a golfer probably requires the best time management of any collegiate scholar-athlete. In the spring, you may go on the road a week at a time to tournaments and matches. So, you have to work with your professors to keep up on your coursework. You have to be able to do your homework and course readings as the team van rolls along the highway to the next golf course.
Note: Most Div. III and NAIA teams have a couple of players who started out on scholarship at Div. I or Div. II schools, but crashed and burned academically. And, if they don't get their time management down, they crash and burn again in the smaller program.
If you can manage all this, you will get to play a variety of golf courses, sometimes in other states. The first place where I taught had a solid Div. II program, and the golfers got to play lots of well-known courses throughout the Southwest USA. The players were some of our better students - Heck, they had to be in order to survive as academic road warriors.
Keep us posted. As an older player, you have maturity on your side.