An ROTC scholarship is most likely seen as an accomplishment by most schools, so it has an advantage there. As for specific schools, I don't think any detachment has the specific pull that some big time D1 coaches have. But, from our family's experience and talking to others (including this forum), some selective schools do consider input from detachments (have heard this specifically about USC and UCLA for instance). Then there are others like MIT that don't have influence (however in their case, coaches don't have much pull either).
What will help you more are well written essays and LORs geared to selective schools (i.e., not what is written for State U with 40% admission rate).
Do your best and apply and see what happens - have some safety schools and have some reaches. There's so much subjectivity in the process that you can't be definite about admission. For what it's worth, I know an ROTC scholarship winner who got into MIT with an SAT only 30 points higher. But I don't know if that put them into a higher category in terms of the admissions rubric. There are websites you can pull up that list the test score ranges accepted into various schools.
Good luck and congrats on the scholarship!