I started using obsidian about a year ago and I have found it to be an invaluable tool.

The key is using it to solve problems you actually have, rather than problems you want to have.

I was losing track of people's contact details --> I made an addressbook in obsidian.

I wanted to track my exercise to find out how much I was running each week --> make graphs

And so on. Your obsidian should get a bit messy before you try to impose order on it. Use it to solve a problem badly (Just writing down how far I run in a daily diary note) then improve (Writing a query to turn all of those notes into a graph).

Personally I don't use any AI with my knowledge base. Good searching tools and a little bit of organization are the most useful thing for me.

Personally, I think keeping lots of notes/links is a kind of digital hoarding. Just like real hoarding, it's an emotional problem not an organizational problem. If you can work out what emotional need hoarding links is fulfilling for you then you're on the way to working out how to get that emotional need fulfilled by something else.