For some odd reason one night I went down a black hole on YouTube of Amtrak sleeper train videos (please don’t judge). Anyway, there are a plethora of videos of Amtrak enthusiasts that vlog their trips. I would watch some of these to get a better idea of the pros and cons.
Biggest cons: the trains are often late, food and water can literally run out so you should always bring your own.
It’s not like in the movies.