Yeah!,
This sounds like a lot of great news. I am so glad you got the new attending.
The diagnosis on your foot is fantastic. Yes, really. A midfoot sprain will heal well and not require some awful surgical intervention.
When you start PT, you might consider asking around and finding someone who does manual therapy. It is a special certification and they move and adjust your bones very gently. My first PT did this, I had heard about it from its use by the Laker's trainer Gary Vitti. I found it to be VERY helpful adjusting mechanical issues in my foot that arose from imbalance after surgery. The foot is so darn complicated. It's like a Jenga puzzle in there. It's nice having someone who knows where everything ought to be and how it ought to move in relation to each part.
Don't fret on the temporary need for enough meds to make you loopy. The important thing is keeping your pain down while you heal!
Sending hugs and healing love,