I don't know what to do

I don't know the levels. My son (7) is verbal, he is highly expressive and communicative. He also has a high degree of hyper focus and cannot understand social cues from his friends. Lately he is having at least one major tantrum per week. Tonight he is extremely upset. He is desperate to get attention and he finally managed to get it when he managed to open up his prescription vitamins and shoved two in his mouth. We are lucky they were the vitamins and not his methylphenidate (he also has ADHD) or his guanfasine. My wife keeps on talking about how he's going to need to go into a hospital at some point. Tonight he's been screaming at us, hitting us, and throwing things at us. I can't get through to him. I hate the idea of him having to go to a hospital and him being away from us. I don't know what it is he needs right now. I want him to know that I'm here for him, that I love him, but he just screams and hits. Right now I'm more the target for violence so my wife told me to go away to our room and I'm just here listening to them fight and I hate it.

I feel like I'm failing him.