Help me find a good enough engineering college (aerospace) and scholarships [CT resident, 3.42 UW, 1330 SAT]

Haven’t decided on the total budget but anything less than 35k is fine as for finding schools that’s the hard part… engineering is a competitive major and I want to attend a well known university so at least when I graduate college I will get employed immediately… issue is that my high school performance is very average and even if I wanted to switch majors I have no experience in art school, the visual arts, athletics… , liberal arts I despise writing essays and bad with literature and struggled with my honors English and AP history classes. Law and business are too extroverted for me. Only other options I can think of is computer science/engineering (which might be a W for me since u can work from anywhere) but I don’t have any experience in programming. As for medicine, I dropped that off back in middle school when I struggled with biology