Scotland's best chance of seeing a solar eclipse in 27 years left some disappointed, though there were moments of magic.