All the best, Sparky. Good facilities will have access to good counselors, and those can be supremely helpful. Be as open and honest as you can with yourself and your counselors and a lot of good can come of that process.
Haven't been through the same things but have done a few rounds of counseling, mostly related to struggles with ADHD and the self worth issues that can come with it. Had to learn to let go of that very Nebraska thing of making a big show of how pissed you are at yourself when you screw up. That song and dance only keeps you in a rut.
It doesn't serve you to beat yourself up and ultimately the people you love don't want you to punish yourself either. Yesterday is gone and you can't un-screw it. You can only apologize to those affected by your actions and begin a new streak of good decisions.
Your journey will involve forgiving people, don't forget that you will be one of those people. But it's not a baptism, you don't say you forgive yourself and you're healed forever. It's a choice you have to make over and over to let go of what you can't undo and make the next, right choice.
Godspeed.