@LHolmes,
“Well I guess that’s it then. Wouldn’t that mean my chances at any fairly selective school are none then?”
It depends on what you mean by “fairly selective.” If you’re talking about the Ivies, yeah, that’s mostly right - chances are very low. Transfers are for exceptional cases (except Cornell, which has a special program that you’d need to qualify before entering your freshman year). You really haven’t shown why yours would be an exceptional case.
But there are other selective schools that more readily take transfers. I mentioned state flagships. Many of them are very good schools.
In looking at a list of transfer rates of top 50 universities, i can see that there are private schools - very good schools - that take a lot more than one or two or a few percent transfers. Here are a few. These numbers are from 2012, so they’re likely lower, now, but it’ll give you an idea.:
Notre Dame: 37%; Vanderbilt: 26%; Emory: 32%. University of Virginia: 37%; University of North Carolina, Chapel Hill: 42%.
Obviously, you need to be academically-qualified for schools like these! They’re great schools! They’re tough to get into! But you seem confident that with your health issues resolved, that you can now demonstrate your academic excellence. If you succeed in that, then there are good schools into which you can transfer. Some of these schools may be good places to investigate, to call them and see what it takes to transfer into them. In some cases, such as with my state flagship, they may be looking primarily at certain feeder colleges. You’d want to find that out. In other cases, there may be special programs for which you may not qualify. So, it will pay to do the research.
But there are definitely very good schools that take larger numbers of qualified transfers than Yale.
As for starting with an open enrollment school, well, look around! Maybe you’ll find someone who is a little more selective who will take you. But you need to remember that schools that are selective need to select on some basis. That basis is largely your previous academic record. From a student’s academic record, a school can observe the achievements a student has already earned, and can project what that might mean into the future. At this point, you don’t have that academic record to demonstrate to anyone what you can do. So, you need to build one. Thus, open enrollment.
It’s less important where you start and more important where you end up.