Getting airborne in a small aircraft is one of those things people assume is out of reach, and it really is not. A trial flying lesson puts you in the cockpit with an instructor beside you, and more often than not they hand you the controls once you are up. It is a proper, hands-on taste of flight, not a passenger ride.
No experience is needed, and a trial lesson can usually count towards a pilot's licence if you catch the bug. Light aircraft, gliders, microlights and helicopters all offer a way in, each with its own character.
The schools on adventuro run trial flights and lessons with qualified instructors. The view alone is worth it, and taking the controls is the bit you will not stop talking about.