Well, I grew up about 15 minutes from there. Was born in Albany, NY and grew up my entire life in Clifton Park/Ballston Lake until I left for college in VA and have since stayed in VA.
I loved growing up there and absolutely love Saratoga. I worked at the racetrack one summer (I DON'T recommend it

) and we would visit Saratoga all the time. Before we got a Starbucks in Clifton Park my friends and I would go up to Saratoga a few times a week.
I went through the Shenendehowa school district, IMO one of the better school districts if you've got kids higher up in the ranks in terms of grades or sports, but if you've got middle of the road kids it's not as great- it's easier for kids to get lost in the crowd and miss out on sports opportunities due to being "not good enough".
I've heard good things about the Saratoga school district- smaller than Shen. The area is nice, I think it may be a bit more expensive in terms of housing but it depends on what you're looking for. If you're looking for a good selection of new but affordable homes, you probably won't find them close to downtown. There's a lot of development still going on in Clifton Park and my brother and his wife recently bought a reasonbly priced nice house in Rexford.
Also, it depends on where you end up working. It's probably a 40 minute commute from Albany, much more in the summer. The summer is incredibly busy there due to the track season. The place is buzzing in the summer, less so in the winter. It's a fun place and I'd like to end up close to it, but not directly in it. I wouldn't be able to stand the track traffic which runs from the end of July to beginning of September.
It definitely is a nice place though! I hope a real resident can give you a better opinion.
