Bone marrow transplant w/chemo - anyone ever done this or know anyone who has?

Got the details of my 2nd regimen of chemo last week from my doc, basically mapped out a 2 week hospital stay in a sterile room locked away from the world - no visitors allowed at all. On the first day they remove bone marrow, then for five days they'll nuke my body with chemo drugs to completely destroy my immune system and the tumors, then inject clean bone marrow after it's over. Once the white blood cell counts come back up and to a decent level they'll discharge me from the hospital but I'll still have to stay at home away from the public for several more weeks, probably into 2022. Thanksgiving will likely be spent in the hospital which sucks because I spent my birthday in a chemo chair already.
I've made a few posts on other sites looking for people who can give me some pointers and what to expect physically and didn't get much in the way of recent experience. Friend of a friend did it 15 years ago and said it's pure misery - that's pretty much all I've gotten. He's still alive and said he's in good health, so that's a good sign. However he didn't know anything about advancements in the procedure or whatever.
Not gonna lie - I'm scared shitless. Yes I know they have medicine for that too. My one and only hospital stay was when this cancer bit first started at the beginning of the year and that was for 2 nights so they could draw blood and run tests. This is going to be waaaaay above that in terms of severity.

TIA for any info.