Self hosting addons and other

hello, i have been wanting to self host stremio addons used by me for some time now but have some initial doubts and gaps in knowledge.

1. i want to self host an index manager like prowlarr or jackett. I have seen people are moving away from jackett to prowlarr as it getting old or something (told by a friend), is it true? are there benefits to switching to prowlarr other than usenet support, or is it just the cool new thing to do?

2. i am currently using comet and mediafusion, but struggle to differentiate between them. i like mediafusion as it offers scrapers like tamilmv, etc... which is very good for regional content here in india (and live content like sports, which requires mediaflow proxy, which i also plan to selfhost). and how does mediafusion incorporate prowlarr when self hosting vs public elfhosted instance? is it similar to how self hosted comet handles it?

3. and are people self hosting torrentio, i have not heard of anyone self hosting torrentio, and is there any difference/benefit over comet and mediafusion, i have found these two to be very reliable more so than torrentio as it goes down sometimes, due to its popularity.

4. and is the always free oracle vps sufficient for it, or should i switch to a cheap vps for all this. i have some self hosting experience with vaultwarden (which is the only one yet i have self hosted). which is hosted using linode at the moment.

thank you for taking your time to answer my questions, and a big shoutout to the devs of these projects, without them an elec engg like me would have no idea about these wonderful things and would be spending tons of money on different subscriptions rn, other than debrid. debrid is amazing. cheers and have an awesome day!