Tried this for twitter as there are some people I still like for their concise content, but I don't want to be drawn into curated corporate doomscroll. Doesn't work as good as I thought, but I still consider RSS to be a valuable tool to put a safe gate to personal internet use

Yea, I dont follow ppl on twitter anymore, but you can use nitter to turn any user into a rss feed.

https://nitter.privacydev.net/elonmusk/rss

For subreddit you can use redlib which has rss feeds, example https://redlib.zaggy.nl/r/insects.rss

Using this as a source, you can combine a bunch of subreddits you like to follow into a single feed for minimal usage effort.

Since you are processing the feeds by now, it is trivial to filter out crap you dont want, such as Musk news.