Yes, a stateroom on a cargo ship sounds like it would be fun. Something to try one of these days.
Availability is probably limited though, as each ship can only take a few passangers: "Cargo ships can carry a maximum of 12 passengers although most vessels only have accommodation for 4 to 6 passengers" [2].