I took advantage of this deal last fall. It really is a no-brainer incredible deal. The OP is right, it is the nicest course in the area (haven't played either of the country clubs) and the toughest (rating is 72 from the blues and 74 from the tips IIRC). Playing this course I know will make me a better golfer. Either that or I'll get so frustrated I'll quit (yeah like that'll happen). I'd like to get in the league too, but right now I work evenings so that probably won't be possible.
I've probably already used around $600 worth of that $999 between the course, range, and indoor facility (which BTW is not only just for putting practice. You can hit full swings and chip also).
I looked at the city course pass and Lincoln Greens. Either of those was going to cost me at least $600/year as I'm outside the city limits, and that didn't include the range or indoor facility.
I personally hate taking a cart and only do this for outings or when I play with one of my lazy friends -) so that wasn't a consideration for me. You'll have to decide that. The course is a hike, can't BS you on that (a lot of distance between some of the holes) but you get used to it.
If you plan to play a reasonable amount of golf over the next two years in this area, I can't see how you wouldn't do this. If you do, then maybe we can get together for a round.