Hello Spatz,
I am a current CAP Officer and a prior cadet myself. I spent six years as a cadet before going off to the Marines. I came back in 2016 and was recently selected for squadron command after a little over six years as a cadet programs officer. I've had many of my peers from my cadet days go on to NROTC, one with a full scholarship, as well as to service academies, OCS and the enlisted ranks. On top of the military folks I know doctors, lawyers, ivy league grads, cops, business owners and more that all utilize their CAP experience to succeed in life.
I've helped multiple cadets apply for scholarship opportunities and the academies, and one of my cadets has been nominated to the Naval Academy and is awaiting his appointment. I can't think of a single cadet that would claim their time in CAP hurt them and most would credit the program with helping them achieve their goals.
CAP's Cadet Program is a phenomenal program, but simply being a cadet isn't going to help you much. You'll have to do the work and be high achieving within the program for it to really benefit you. My advice to you is to visit some squadrons in your area and see what they do. You say CAP isn't really useful in your area. That may be the case as far as our emergency services missions go, but there is a wealth of opportunity to pursue leadership education, career exploration opportunities, awesome special activities and other experiences to be had. These can both aid you in achieving your goals and also give you experiences and knowledge that will be useful to you for the rest of your life.
CAP has been very, very good to me for most of my life at this point. I hope you'll give it a chance to be good for you. Maybe in 20 years you'll be the old man writing to a 15 year old lad encouraging him to be the best he can be. After all, that's what the Cadet Program is all about: transforming young Americans into dynamic citizens and aerospace leaders.