Spot-beam effect in grazing atom-surface collisions: from quantum to classical