There are two types of golf in my opinion. Golf with friends, and tournament golf. The two are VERY different.
Tournament golf is extremely stressful, every shot makes your heart pound and your mind race. One slip up and you're done for the tournament. It's the most exhilirating thing some times and the most discouraging at other times. The good news is, there has been a huge increase in the number of handicapped tournaments being put on across the country.
These tournaments (are supposed to) flight players based on their handicaps and even the playing field between scratch golfers and the average "good" golfer. I've played in many of these events and they are GREAT ways to get your first tournament experience without dropping a huge load of money with no chance of placing. A lot of these tourneys also have side games (skins, 2 games, etc.) so even if you play a few bad holes, you still have a chance at winning some coin on the holes you play well.
http://www.dallasitour.com . Check it out - you may have something like this in your area.
Good luck - and hit 'em straight!