How exciting is it to fly in a general aviation airplane, which is much smaller than an airliner?
Well... about as exciting as you make it! I think it is perfectly exciting (meaning not unsafely too much!). Last summer I flew for half an hour, up the Atlantic coast of Labrador, never climbing more than 100 feet above the water, though I guess more incredible awe inspiring, than mere exciting.
Try as much as you can, and choose for yourself!