Creatively speaking, this deal could work in Spidey's favor big time.
Spider-Man is one of those characters that has a "pocket universe" - a large set of mythos within a larger set of mythos - and always had a degree of independence that someone like Iron Man does not. Whereas the Avengers need solo stories almost as much as they need team stories, and in cases like Widow and Hawkeye they need team stories even more. That's why a lot of Iron Man/Cap/Thor villains are also Avengers villains.
On the other hand, Spider-Man teaming up with certain characters has always been a great aspect of the Marvel mythos. He may not always work as a team player, but you just can't resist seeing him interact with other characters nevertheless.
I'm hoping this allows them to strike a perfect balance, where we have a natural fitting Spidey appearing throughout Marvel but his own solo stories are self contained enough to let the Spider-Man mythos stand on its own.
Basically you need to watch the solo films to get the full MCU experience, but you don't need to watch all the MCU films to get the Spider-Man experience.