We went just before Covid, so maybe not recent enough for you. Vancouver to Banff - gold service with overnight stays in motels. It was WONDERFUL.
At least for the gold level, you sit in the upper deck with wrap around glass windows - since the rail is usually in valley's, you get amazing views...