JC, I wanted to offer my sympathies for all the chaos in your heart and head right now. I am the BS who bungled discovery and recovery in the worst way, no thanks to my cake eating, lying WS, so I almost cheered for you a few times here. You have handled things about as well as this club's members could have wished for, and I'm so glad you found this site before you confronted and knew what to expect. I was a deer in the headlights for the first year before I found SI and it took a couple of years until I realized just who and what I was married to. It was a hard reality pivot.
My childhood was not as unfortunate as yours, but my love life was a never ending story of having my heart broken and being used and discarded and of course being cheated on. I thought before I met my H that my Dad was the only man in the world who had shown me what love was supposed to be like in an honest and committed relationship. I bought hard into the mythology of my WH being The One, the Only One I could trust, who had my back 100% and loved me just the way I was, as much as I did him. I fell so hard from the life he pretended was perfect. I got cheated on for a very long time, and my recovery rollercoaster went through many unexpected twists and turns. I wanted to offer two bits of advice. One, is to accept that your emotions are going to do what they are going to do, and it is really OK to feel all those feelings, whatever they may be. Please go easy on yourself if you find it harder to be the version of yourself you mean to be, want or need to be. I failed myself a lot in the early phases of the betrayal, and I had a lot of work to do to forgive myself for not being as smart as I should have been - not just in figuring out what was going on, but in figuring out how to proceed and how to take back my life, and especially for taking so long to do it. So go easy on yourself, be prepared for all that your broken heart needs to heal. It's early for you yet but I always recommend Living and Loving after Betrayal by Dr. Stosny as a touchstone to yourself and your path forward.
Second, the mythology of The One, the shattered notion of a relationship that defied all odds, a love that was true and pure and sustaining..... When that shattered for me, I fell into the hole created by that lifetime of hurt and betrayal, all the way back to some very old feelings from my earliest ages of not being worthy or lovable. I hope none of that crap finds you, or camps in a corner of your mind, because it became debilitating for me years downstream. I could not find my way out until I found a therapist who was able to quickly understand who I am, how brutal this betrayal was, and used EMDR to break the bonds of all those old thought patterns that were dragging me under in the wake of this stupid mess I did not make.
I'm not sure what your future may hold, any more than I am sure any more about my own. I am still with my WH, and he's not done a fraction of the confession or crying that your WW did, and none of "the work" I needed him to do. I would have never guessed how emotionally limited he actually was any more than I could have guessed I could stay with someone who betrayed me, and yet, here I am. It has taken a lot of soul searching and a lot of reframing to accept the place I find myself now. It also took a lot of math, lists, pros/cons, to come to a stay/go decision, and at our ages, together seems to be a better end to this story than apart. That is, so long as I never catch a whiff of untruth, unexpressed resentments, unempathetic or sneaky behavior. I managed to find my standards and live by them again, and will not hesitate to walk away now. In the early years, it was my love for him and history that kept me trying, but I will admit the love is a hybrid version I had to come up with to stop some of the hurt. I guess you could say I love much less freely than before, and I'm not as invested in any aspect of my marriage as before.
I hope whatever you decide, it is what your heart and mind can agree upon. My first IC encouraged me to take all the time I needed to decide what to do, saying you can always leave. Just know that is the right choice before you do it. From your posts, it is obvious that you are an amazing, thoughtful, caring, intelligent person. As others mentioned, you are also quite young and should you choose to move on, could still have that family you thought you could not have. I'm almost thirty years ahead of you and I want to beg you to not let this define you or break you in any way, and urge you to have your best life, whatever you decide that needs to be.
Keep coming back for support, for help and if you don't have an IC, I hope you find yourself a good one. It took a good IC for me to finally accept that NONE of this, NONE of his stupid choices or terrible behavior were my fault, or even about me. Once I began to see him as the damaged and stunted person he obviously is beneath the veneer, I realized how much of what I believed about him was what I wanted and needed to see, not actually who or what he was. The ripples of realizations that have come to me on this journey have been a lot to process. If it weren't for this forum and all these lovely kind broken hearted and healed people who came before me, I'm not sure I would have gotten through intact. Keep leaning on all the support you can get, and don't be afraid to reach out in real life or online when it piles up, because it will. I can't even remember how many times I wrote in my journals that I was turning the corner on my recovery and things were better, I was better, only to fall into another pile of emotions and confusion that drug me down again. This is the ultimate existential crisis, so please take care of yourself and reach out for support if you need to. Best to you, whatever path you find yourself walking.