With pretty reasonable high speed rail, that should be no more than a 4 hour trip. At which point it is very competitive with flying in terms of time.
For cost, it looks like a round trip on Amtrak is typically $200, whereas a round trip flight for two weeks from now is around $300.
I much preferred the relatively relaxed nature of train travel, and it only bit out an extra hour or two of my day. With high speed rail it wouldn't even be a contest.
Two things to keep in mind by rail to Montreal: customs add 1h, and in summer, if the rails are too hot, per Canadian regulations, the train cannot go faster than 50km/hour or something ridiculously slow like that, which adds another hour or two. Onboard wifi only works when in the US, and because of the mountains in upstate NY, the signal can be very flaky and slow.
This is just always going to be the problem. It's ok for some mild entertainment but it's not viable for regular travel. A flight to Montreal is like an hour and probably half the price.