Not in Scotland? I had one fly into my living room window and stun itself. I picked it up and placed it safely away from the local cats (in the hen run). I had plenty of time to get the reference book out and identify it. This was in Southern Scotland, about 30 miles from the borderFrom "Woodpeckers of Europe"
Lesser Spotted Woodpecker: distribution and range
Europe’s smallest woodpecker is quite widespread and often fairly common locally, in the right habitat, across Europe. It is, however, easily overlooked due to its size and tendency to forage in the canopy, and thus its exact distribution remains somewhat unclear. Lesser Spotted Woodpeckers are found from Iberia and the UK (but not Ireland and Scotland) eastwards across the continent into Siberia and Asia as far as Kamchatka and Japan.
Not exactly rare are they?