Welcome to the Q&A Forum

I have the simplest way to think about this. If the link is pointing out to the website you trust and you think your audience will find it useful, keep it followed. However, if the links are not trustworthy, atleast put a no-follow the link. Other then that there are Googe guidelines as you mentioned in your question. I think no following social media and wiki-pages is up to you as it will not make much of a difference in my opinion.

Great, thank you!