OK. Rather than pick out a RAM model for you, I'll tell you how I search for compatible RAMs once I've settled on the motherboard and CPU (others may have their own approach for the same purpose).
Go to the motherboard manufacturer's site --> the specific model --> support --> Compatibility --> memory. This is the link for your case https://www.msi.com/Motherboard/MPG-X870E-EDGE-TI-WIFI/support#mem
Click the button for your CPU series - 9000/8000/7000. That will be 9xxx for you. This will bring up a long list of all memory models they've tested on the motherboard with the selected CPU series.
It's a tedious process to go through the whole list, so you can use this shortcut: Visit your favourite online/offline shop and see what they have in your price and performance range - like the size, speed, latency, RGB, aesthetics, etc.
As an example, I've selected "G.Skill Trident Z5 Neo RGB 32GB (16GBX2) DDR5 6000MHz RAM" from Vedant Computers. (The Trident series is G.Skill's premium line). This model is CL30.
Look at the detailed specifications and copy the model number which is F5-6000J3038F16GX2-TZ5NR. Paste this number into the search window at the top right over MSI's list of compatible RAMs and press ENTER. If it's on the list, it will show up in the search result. This model does.
That was just an example. You can use this process or your own variation of it for other RAM models.