I think you're starting to understand the size of the hole you're in, OP. You didn't get there on your own, though. As well him clearly abusing you, his parents have acted as flying monkeys or at least as apologists. They said:
I forgave him his parents said he put alot of pressure on himself to give me a perfect home and on himself...
So he trashed the house due to the pressure of needing it to be perfect? Sure, that makes sense.
His parents says becouse he is not used to.kids and never had any so dont know how to react.etc .
But you were supposed to take his instruction on what your ds had to do if he wanted to be able to stay?
There is no point bothering to try and understand why he acted the way he did. Put your energy into understanding why you acted the way you did.
anyway i slept in there 2 nights then he accepted i was sorry he said he been stressed about work etc etc wasnt coping
He threw you out of your own bedroom until you said sorry to him?
And yet he feels he isnt that bad as long as I am with him.and support him he cant do it alone...he wants me home to support him...
But you were with him during all of the incidents you've mentioned. All the times when he had a so-called breakdown, when he couldn't cope. You were there. And all he did was use you as a punching bag.
It won't be 'different this time'. Except that you will feel even more responsible for his behaviour (since presumably any further outbursts will be the result of you not being 'supportive' enough).
I would suggest that you rent a place and tell him you will be supporting him by staying away whilst he gets his shit together. His behaviour is neither your fault nor your problem. Your focus should be on your children and yourself.