I'm not a Cincinnati native, but my sister and her family live there and have for nearly 50 years, so I feel like I know it reasonably well.
Cincinnati's Union Terminal is iconic (see Cincinnati Union Terminal - Wikipedia ) but also far from downtown, by railfan standards. It's not near any hotels that I know of and is in a kinda dicey neighborhood, and is served by just one bus route, #49, with little or no wee-hours service; see https://www.go-metro.com/uploads/routes/maps_and_schedules/RT_49.pdf. So, unfortunately, you'll probably have to take taxi or similar.
I don't know your budget but if you like grand old hotels, Cincinnati's Netherlands Hotel (part of the Hilton chain) exemplifies its era, and you might ask about pickup; what do you have to lose? It's only a 10-minute trip and probably even shorter at that hour.
I like Cincinnati but am admittedly biased: it's remarkably similar to Pittsburgh in many ways, topography and architecture and population, but it'd be much easier to plan a fun and car-free visit to Pittsburgh. (See suggestions at Pittsburgh PA.) And for whatever reasons (fewer students? stolid German heritage? Andy Warhol not born there?) Cincinnati has a more Midwestern feel while Pittsburgh is edgier. But hey, judge for yourself!
Cincinnati's Union Terminal is iconic (see Cincinnati Union Terminal - Wikipedia ) but also far from downtown, by railfan standards. It's not near any hotels that I know of and is in a kinda dicey neighborhood, and is served by just one bus route, #49, with little or no wee-hours service; see https://www.go-metro.com/uploads/routes/maps_and_schedules/RT_49.pdf. So, unfortunately, you'll probably have to take taxi or similar.
I don't know your budget but if you like grand old hotels, Cincinnati's Netherlands Hotel (part of the Hilton chain) exemplifies its era, and you might ask about pickup; what do you have to lose? It's only a 10-minute trip and probably even shorter at that hour.
I like Cincinnati but am admittedly biased: it's remarkably similar to Pittsburgh in many ways, topography and architecture and population, but it'd be much easier to plan a fun and car-free visit to Pittsburgh. (See suggestions at Pittsburgh PA.) And for whatever reasons (fewer students? stolid German heritage? Andy Warhol not born there?) Cincinnati has a more Midwestern feel while Pittsburgh is edgier. But hey, judge for yourself!