It’s always better to attend a 4 year college starting freshman year if at all possible if med school is your goal. You don’t need to attend a selective college or a private college to be viable med school applicant. Any of your Florida public universities are just fine for pre-med.
As a FL resident, are’t you eligible for Bright Futures?
Your stats so far look pretty good. What are your financial constraints for college? (IOW, how much are your parent able pay toward your college expenses each year?)
If you post your stats, your state of residency and your financial limits in the financial aid, the posters there will likely have some good suggestions for you.
FYI, Yale accepts very, very few transfers each year ( <25 according to last year’s CDS).
Emory’s nursing program does accept transfers. Here’s their webpage: http://www.nursing.emory.edu/admission-and-aid/bsn-programs/bsn-transfer-option.html
Pay close attention to the required coursework to considered by the program.
I don’t believe Georgetown offers any merit aid, just need-based aid. Emory offers a limited amount of merit aid TO FRESHMEN as well generous need-based aid. So it’s likely those MDC transfer students you mentioned received generous NEED based aid due their family financial circumstances which has no bearing on whether they had graduated from MDC Honors Program or not.