Well, there is still a "long-term" need for your O'Nell Cylinder to fly somewhere else - the Sun won't be there forever.
Though the question is for right now, in the future, I suppose much more will be possible. Even with more powerful engines, we will not need generation ships, as the time, subjective, will be less.
Tau Zero by Poul Anderson is a good novelette on the subject.
An O'Neill in orbit can also provide a base for building spacecraft for exploration of the Solar System and beyond. In a sci-fi setting I made, there are those, plus space elevators, where the orbital stations provide Earth with it's manufacturing and food production, and the Earth is like a park.
An O'Neill Cylinder that stays in the solar system has a few conveniences that it would not have in deep space flight hasn't.
I mentioned up-thread of using them in the Mars cycler orbit, they can be stepping stones. There is an old Soviet sci-fi film, A Dream Come True, where they sing
"Apple Trees will bloom on Mars ..." A favorite of mine as a child.
One of the really hard parts is the time in isolation when you're too far from any star system to mine resources or collect solar energy.
True, however we could find a rogue planet, current research says they might be more common than we previously thought.
There is always going to be that fundamental human curiosity that drives us to explore.
I am 100% for space exploration.
And there is always the Mormons.
Until the Belters steal their ship.
(I was voted one of Avasarala's biggest fans on Shohreh's FB page, unrepentant Earther that I am.)
