The idea that Peter Parker possesses micro-hairs along his hand is pretty good, but canon only to at least Sam Raimi's cinematic universe. There's no real substance to that in the comics. There's also an "official" handbook explanation, and that is that Spider-Man somehow can enhance the flux or inter-atomic forces between atoms to bond himself to any surface. The handbooks aren't exactly law, but probably the closest you'll get to a "canon" explanation.
Recently I've actually been developing a theory of my own to explain Spider-Man's ability to adhere to surfaces, and I believe it to be far more consistent with comic book showings and the ability of other characters.
Electromagnetism
And yes, that's ridiculous and not at all scientific, but you might be surprised at how many "spider-y" people there are in Earth-616 that possess strange bio-electrical abilities. Jessica Drew, the first Spider-Woman, is able to generate bio-electrical bursts of energy dubbed "Venom Blasts", used to concuss or overwhelm her enemies. Miles Morales, a Spider-Man from an alternative reality, possess this exact same ability. The generation of electricity obviously isn't at all very spider-like, yet these two characters possess this very same ability. Interestingly, Jessica Drew's power-set in general came from a very similar source as Peter Parker's as well, as she was bombarded with radiation and infused with spider genetics.
Though it is elaborated on in the official 1992 MARVEL handbook that Jessica Drew's ability to adhere to walls isn't through some bizarre electromagnetic effect, but through the excretion of an adhesive fluid from her pores, I think it could be argued that electromagnetic forces might still play a role. Electromagnets utilize something to channel a current through, so perhaps this fluid isn't necessarily sticky, but a ferromagnetic substance she can manipulate to her whim? Assuming this we could also start to consolidate all the different Spider-Men/Women's variations on wall-crawling abilities as only being partial explanations and mild variations of the same phenomenon.
Another character, Mayday Parker, the daughter of Spider-Man from Earth-982, provides even stronger evidence for Peter Parker's potential to generate electromagnetic attraction. She herself climbs surfaces with an ability dubbed "Bio-Magnetism", a strange power that not only allows her to generate a bio-electrical field that can be manipulated to magnetize herself to any surface but also repel herself from them. An interesting quirk of this power is that can magnetize people and objects around her merely by touching the surface they're in contact with.
Though Spider-Man has never had a showing like this, it's not unreasonable to assume that his own biological daughter, who also possesses spider-like powers, derives her ability from his own. Peter Parker, as well as the other Spider-Men and Women, might even possess the same potential to perform these bio-magnetic feats but either are unaware, too inexperienced, or don't possess quite the same level of control over their own bio-electric fields. She implies the very same here, in Spider-Verse Team-Up #3.
I think Bio-Electromagnetic attraction might also explain even "The Mark of Kaine", an ability of the Scarlet Spider (II). He uses his wall crawling ability to brutally disfigure the faces of others, tearing aware their skin and leaving unusual scarring. In this particular scene, smoke fumes can be seen rising from his finger tips as he performs this act. If he truly is just a more aggressive, but genetically identical copy of Peter Parker, then Peter should theoretically be able to do this too. Why smoke, though? Well, perhaps Kaine is simply "amping up" the bio-electric current pumping through him to electrocute and sear the flesh of his enemies.
The idea of Spider-Man harnessing some electrical phenomenon to cling to surfaces isn't even a new idea. Stan Lee himself wrote that Spider-Man used static cling to achieve the illusion of a spider's adhesion, and this is how Electro was able to nullify Spider-Man's wall crawling grip. If he was harnessing this "bio-magnetic" force like his daughter, than this goofy bit of Silver-Age sci-fi could still be relevant to the science behind Spider-Man's wall-attachment capabilities.
The only part of this theory I'm not quite sold on is how or why his body would even act like an electromagnet. It's a very ridiculous, very un-spider-like explanation, but I think it nicely unifies the various wall-crawling explanations for Spider-People into one major ability, as well as illuminates the odd trend of powerful bio-electric powers they seem to possess...
tl;dr: Though the official MARVEL handbooks state Spider-Man's wall-crawling ability comes from some telekinetic alteration of inter-molecular bonds, I believe it's far more consistent with the source material that his unusual "stickiness" comes from the generation of a bio-electrical aura, and manipulation of it to electromagnetically attract himself to surfaces.