I’ve ridden in airliners, small planes (as passenger and pilot), and twice in a helicopter. The main differences are:
There’s a huge difference between an airliner and a light aircraft. In an airliner, you’re lucky to have a restricted view out of a tiny window. I like to know where I am; it’s hard to pick up any landmarks when the view is so restricted. You don’t know which way the next turn will be, or if there’s something special you want to see from the air, you don’t know which way to look.
Light planes are like small cars, you can see out the front and both sides. If you want to see your house from the air, just tell the pilot and you can go right there. And you can always see the horizon, which tells you how steeply you’re banking and turning. My flights in a helicopter were similar.
It depends where you’re taking off from. I did most of my flying at airports with large runways; I could almost land crossways on them. It’s a comfort to have such a big margin of error, thought I tried to never use it. My first flight in a helicopter was from the back corner of a department store’s parking lot. I’m sure they can set down on a helipad ten times out of ten, but those telephone poles looked kind of close. Some airports are like that, too; the runway’s about as wide as a two-lane road.
I have to say that I have ridden in the back of a CG Helo. When I was in the back (and therefor I did not have a window beside me), I got sick pretty quickly.
When I moved up and they opened up that door, it was like pure heaven. No more sickness and there is nothing between you and the outside. It was great.