Oakland Strokes, PennAC and Sarasota are all top notch. You are correct with regard to specific college run rowing camps as they do nothing for recruiting chances specifically.
As to your son being a novice I’ve heard of plenty of recruits who were novice rowers but accomplished in other vigorous sports that were recruited. If he’s a strong athlete, has the dedication and is coax able the programs will take notice!