The Micro 820 and some other Micro 800 models can be used well to get Modbus RTU to Compact/ControlLogix. I have Micro 820 and 850 running the Modbus communication on-board then being read by MSGs over Ethernet from other controllers. The Click is another small controller I would consider for that. It can do the same, plus it could also be added to the Rockwell system as an IO adapter so MSG management is not needed.
Since OP of this thread mentioned CompactLogix, if using a newer 5380 controller or a remote 5069 rack, I really like the 5069-SERIAL module for Modbus communication. ProSoft is another go-to for Modbus and Rockwell. Anybus is also well liked, but I haven’t used them yet.
I have not used the 1769-SM2, but I’m sure others here have. In the 1769 chassis, my first Prosoft from scratch project used MVI69E-MBS. The ProSoft was a bit confusing at first to set up with the IO table fully open and nothing defined. Once I figured out a clean logical layout of the data and status from the commands, I really liked the module.
If you have specific questions, starting a new thread will be best for getting some help. Let us know the specific hardware you're using, what you have tried so far, and the results you’re seeing. More details is better.