Best Spider-man film made was Into the Spiderverse, although more of a Mile Morales film as opposed to Peter Parker but still. Problem is the films have to appeal to their main audience, sadly that's not full grown adult men who read comics, it's kids. A Spider-man film dealing with his issues over his marriage, death of Aunt May or issues he has juggling being a hero against having a job might not be that fun to watch. Works well in comics as they allow for an ongoing soap opera like narrative.
Spiderverse did great for many of those things but kept it simple and light hearted as Miles was the star, not Peter Parker. The Peter we have in the MCU films just isn't Peter Parker we know, heck none of the characters really are. MJ isn't MJ, she's Michelle someone, moody emo girl, not the outgoing gorgeous girl next door from the comics. No Ben, Tony is the Ben of that world. Heck, even Peter Parker isn't himself and is being turned into more of a Iron Man Jr (Sooner they add the Young Avengers to the MCU the better, get Iron Lad in there), no spinning wise cracks in fights because he's nervous, no achievements or sacrifices of his own like Peter would do.
I was talking to a friend of mine about the next set of films and was saying that Peter Parker needs to be the next big character in the MCU because Peter IS Marvel, he's the star, always is always will be, the idea that plain slate Carol Danvers is the next front of MCU is stupid, she's not likeable, Carol never has been. But my friend made a good point, IF Spider-man becomes too successful in this guise of the MCU, Sony still have power right? They can say 'alright' we are pulling him out of MCU and just end the deal. Marvel don't want that, they want control of their characters.
Sony are at least doing other things with their purchased licence with Venom, Morbius and Spider-verse, all more mature themed (hopefully on Morbius), shame Universal aren't doing the same with Hulk. Seriously, Universal, where is our She-Hulk? I want a lawyer film with a big green woman at the helm.