I lived outside Cinci for four years of college, there are a number of items at play here:
1. Ohio has never really been supportive of rail service. We say that about Indiana, too, but Indiana spends millions per year on NICTD while Ohio has nothing of the sort.
2. It's not hard to see why. Service was mostly PRR and NYC when they were in bad shape, completely broke Penn Central, and Amtrak in wee hours. Virtually anybody alive in Ohio thinks passenger trains suck.
3. The Cleveland RTA has been poorly managed with no real strategic goals since the 1976 handover. The Cinci subway was not completed in 1925 and doesn't really serve a useful pattern if tracks were laid in tunnels today.
Given those three facts, the optics are bad and support is minimal.
If Cinci had meaningful service, a new small station in a good neighborhood is desirable. Cinci is spread out from the airport way down south, a quiet downtown, some eastern and western suburbs, very vibrant northern suburbs, and a metroplex stretching to Dayton. There is Xavier, Miami, and U of Cinci plus U of Dayton and Wright State up north. GE has a jet plant, Fifth Third is downtown, and Wright Pat AFB is halfway to Dayton.
The automatic answer to a station location is downtown by the ballpark, but that's on a shortline and is hard to get to. Orginally there was also a "suburban" station in Norwood but that's now urban and too close, so the suburban stop might be Fairfield or Hamilton, or even Oxford.
For a new station, though, you need meaningful service. Number one in my book is breaking up the Cardinal. It's an infrequent slow dog at the wrong time. 1x to Washington and 2x to Indy/Chicago daily. Then, if you can finagle a new start, a TRE-like Dayton shuttle. No food, cab cars, high density. If you they could stretch it, CVG airport, downtown Cinci, then up NS or CSX through Hamilton, Middletown, Miamisburg, Kettering, Dayton, and terminate at either Dayton Airport, Wright Pat, or Springfield.
Odds of fixing the Cardinal? Maybe 30%.
Odds of a Dayton-CVG shuttle? Maybe negative 12%.
The new Acela: It's not Aveliable.