First off, if your takeaway was that "practically all types of link are dead and besides that they will not bring any use, they also will damage the performance of the website in Search Engine" -- you need to go back and re-read those articles, because that is not the case at all.
The links that are of less value are "built" links -- that is, links you create yourself. When you attract earned editorial links
-- that is, links that other webmasters place on their sites because they like what you offer (or at least, they like a bit of your content) and want to share your offer (or your content) with their own visitors -- those are still quite valuable.
You might want to check out Eric Ward (a.k.a. "LinkMoses"). He's a linking expert, and has a lot of good free advice (and a useful paid newsletter) with ideas and suggestions for gaining good links.
As to the links that are showing up in Google's Search Console, don't worry about them. As long as you don't have any sort of warning from Google about them, as long as you didn't place them, they're almost certainly not hurting you. Likely Google was ignoring them to start with.
Spend your time and energy on attracting and earning solid editorial links instead. Just a few of those will be sufficient to send the right kind of signal to Google.