The attraction of acceleration is that their is speed as an aftermath. Not so much speed, but the sense of velocity and freedom. Imagine being launched into the air.
Nobody enjoys stopping, as it just shows they're still anchored to this rock.
Having just been to the NHRA finals, I wouldn't say that it's about acceleration. As a spectator, you really don't see acceleration, at least not what we view as acceleration. Rather, the cars are stopped, the tree blinks, and they are going. Obviously they accelerate, but they accelerate to probably 80-85% of their top speed very quickly, and as a rule, the acceleration happening later in the run simply isn't perceivable by a spectator (at least not me).
What is apparent, is these things are just flying down that track.
To bring this to motorcycles, one of my favorite memories was watching Superbike at Miller.
From our stands just before the final turn, you could watch the bikes dip in to the turn, and then start their run down that HUGE straight. You'd watch the bikes as they'd tip back upright, and the riders tuck in, pour on the power, and start upshifting. Even more exciting was when you watch how the guy in front (Biaggi, typically, with that Aprillia power) pull the guys behind him like tin cans.
I'm not even in the seat at my heart sings in tune with the motors as they fly down that straight. What's exciting is they going quite slowly exiting that turn, and then they roared right up towards top speed that they could get at the altitude. Not just one rider, but all of them, some of them faster than the others. it's a long pull, a deep breath, to the top before the heads pop up, the fronts crouch down under braking, and the knees pop up read for the turn.
The acceleration is part of it, it's the part we feel. We don't feel velocity once we're there. We simply perceive it in relation to others. I'm going 1000MPH just sitting in the chair, plus however fast the Earth is orbiting the Sun, plus however fast the Sun is dancing through the Milky Way. But, I don't feel any of it. I don't sense it.
When I tried skydiving, it was the same thing. It was completely underwhelming to me.
You jump out of the plane, but theres no real "stomach" drop that you'd think you'd get, since you're not standing still. You're already going 120MPH forward, so that, slowly, decelerates as you transition to 100MPH of vertical terminal velocity.
So there you are, going 100MPH in the air and what does it feel like? Nothing at all. It feels like a cold wind in your face, but you have no sense of speed, as there's nothing to contrast it too. The horizon and ground are simply to far away. Only if you fall past someone who has already popped the chute would you have any real sense of speed. Otherwise, it's just a cold wind.
Contrast that to what those guys who ride skateboards down hills, or in that 'Out of Nothing' movie, setting speed records with their heads 1 foot off the ground. That's speed on steroids. That's "you can kiss the asphalt speed".
The acceleration is a thrill, especially in that video of giving those rides, because the passengers are not in control. They don't know how hard it will hit, or when it will end, or whether the driver is going to crater them in to an abutment for flying too fast down a city street.
As they say, "Faster, faster until the thrill of speed overcomes the fear of death".
But in your hand, when you do it, when you have the throttle, it's different. It's power in your hand. It's speed at your control. It's exciting getting there, but being at speed is I think the reward folks are after.