I have oodles of books on sacred places and sacred sites but have only visited so many. Never forget, anywhere can be magical, especially in the artists 'magical times', the blue hours (twilight) and golden hours (post dawn and pre-sunset) or illuminated by firelight or candle light - anywhere with a bit of peace and quiet and/or mild weather to meditate and observe the world or the ambiance. The perfect lighting is transformative.
Equally with all the wrong elements, anywhere can seem devoid of magic (usually due to a surplus of noise, bustle, disturbance, people and crappy weather). Many a pagan pilgrimage has been spoiled by tracks reduced to bogs and the buzz of tourism.
Myself I have a particular fondness for the rolling landscape of the Southwest of England, I'm less keen on how swiftly their weather changes (the only part of the country it was like experiencing all four seasons in one day).
As a friend of mine said 'if it wasn't for all the bloody rain it wouldn't be so green'.
Magic in my experience is personal. If you don't feel a kind of personal or spiritual connection magic simply just won't flow regardless if you are on King Arthurs seat or King Arthurs privy
... the silver in the strands, the gold within the green...