I've got some experience* with NESCAC recruiting, so just wanted to add a little clarification. Most first-choice NESCACs (Williams/Tufts/Amherst/Middlebury/Wesleyan/Bowdoin) give only need-based financial aid. At those schools, there are no scholarships or other aid that is not related to financial need; coach pull/juice/slots with admissions is the principal initial value of being a recruited athlete. There are a few NESCACs (e.g. Trinity and Conn College) that are slightly less selective during admissions and that do give financial aid based on criteria other than financial need.
*I've got one kiddo playing lacrosse at Midd and another playing soccer at Wes. Both were recruited by multiple NESCACs (including Williams) and each turned down mid-level DI offers while they waited for the NESCAC pre-read/offer window to open.