I bought this one: https://www.amazon.com/gp/product/B0753CZ8MC and it works just fine.
Wii to hdmi https://www.amazon.com/PORTHOLIC-Converter-Compatible-Nintendo-Monitor-Supports/dp/B0753CZ8MC
hdmi to vga or dvi https://www.amazon.com/HDMI-to-VGA-Adapters/b?ie=UTF8&node=14570285011
https://www.amazon.com/Amazon-Basics-Adapter-Cable-1-Pack/dp/B014I8UQJY/ref=sr\_1\_3?crid=BGSINLRA4EVW&keywords=hdmi-to-dvi+adapters&qid=1681873267&s=pc&sprefix=hdmi-to-dviadapters%2Ccomputers%2C396&sr=1-3
For example this one
I am currently running this with this and it works just fine.
You don't have to use RCA adapter, Just use something like this. I prefer Composite but I've seen some of my friends using it.