The Lakeshore Limited line of Amtrak goes right up the Hudson. I would check times, though. Pre-pandemic it left NYC around 3pm-ish, so you got to see the sunset and it was glorious. Not sure if it’s still the same schedule though. It has a number of stops outside of the city.