After researching most of the videos and articles, and working with different engines, I came to an interesting conclusion.
Of all the abracadabra gambits, the Stafford Gambit is objectively the worst one but at the same time practically the best.
He really did a good job of finding different tricks, traps, and resources in the Stafford Gambit and brought it back to life.
I believe if Eric was born 100 years ago, the Stafford Gambit would have been called the Rosen Gambit smiley
Unfortunately, the gambit is too dubious, and White has multiple ways to refute it.