I've travelled down there by car and train, but not by boat. It is very impressive. Someone I know has been cycling along the Rhine recently. That could be a nice way to see it. You could stay in those fancy hotels to recover.

I think it's still a major cargo route as I've seen some big ships on the river.