Pauly-
I think the competitiveness is entirely based on the class. My class is really supportive and laid back and not that competitive. The 1L's are a lot more competitive, but they also get a lot more accomplished for our school. They are always planning events and raising money, where my class just doesn't care that much.
The job prospects are great in Albany but if you want to get down to NYC Big Law you really have to be in the top 10% and even that's not guaranteed; you should probably be in the top 5%.
Overall, I really do like the school.