You can go to a CC. My S took the transfer option and has happily completed his transfer.
He went to a 4 year public school, but has a friend who went to a local CC and is super bright, doing really well at Cornell. They really don’t care where you go, so long as you take the right classes and get the A/Bs.