I feel like him being a D-lister was kind of the point. Everyone missed the obvious fact: that the Spider-Verse trilogy's whole bit is that Miles origin changed things. Chaos, disrupted anyone possibly predicting stuff.
So there we all were awaiting Lady Ock's return or some interdimensional Goblin cabal, no one once considered the main villain would be someone completely unexpected.