I will chime in with general college life thoughts. Both my kids found colleges that fit them and their unique personalities.
One is in small, active Honors College at medium size Public U. Having 2 Advisors is super helpful, and early registration for both classes and dorms is a big perk. Small class sizes for Honors Classes, getting out of some boring gen ed classes (that would be 150+ students in large lecture hall) is another perk.
Biggest Perk of any Honors College is instant community. First two weeks Older Honors Students mentor Freshman Honors students, lots of social activities and all Honors Staff have offices on first floor of Honors dorm. Tutoring by fellow Honors students at no charge, again held in study rooms in Honors Dorm.
Other child was in a special program on campus at a small Private LAC and lived in what was practically a sorority dorm. All students in this program were required to live there all four years. One dorm for girls, one for boys. Older students mentored younger students. They also got training from the program staff. Great personal growth for my child.
You have great choices, and you have gotten great advice on the academics and honors programs. I suggest you think about fitting in, the dorm living situations, and what would best suit your personality.
One child is at a school where every student gets their own tiny bedroom in a four person suite with 2 baths and a mini kitchen and living area. Means the world to my kid who values his privacy.
Other kid shared larger room with one roommate. Walked down the hall to a communal bathroom. And there was a kitchen area on each dorm floor. It worked fine for her.
I would tell you to choose an Honors College if you were my child. Then compare the perks of dorm, food, community, activities, and perks like early registration.
You can be successful anywhere, and you can also miss out on lots of opportunities anywhere. It is up to you to go to office hours to talk with your professor and get to know them. Get involved in study groups. Ask for help before you are drowning. And take advantage of mental health counseling to help with transitioning to adult life.
You seem to be a rational student who is thoughtfully considering options. Best of luck to you!