Just my own opinion; but, I like high schools around 1,000 to 1,500 students, which is actually large for the Northeast. Big enough to offer everything (sports, marching band, AP classes, etc.); but not overwhelming.
My high school at the time was about 1,200. We had 2 guys in my class play D-1-FBS football (Virginia, Army) and 2 more went the following year (Syracuse & ND [the ND kid apparently confused the lucky four leaf clover with too much of a different green plant and washed out ,guess he should have gone to Florida). I played soccer; but, was not good enough to play at UConn.