I am one such tab-overloaded computer user.
There are a few tools that help me effectively manage a large number of tabs. (No, Firefox's Tree Style Tabs isn't one of them - while it is great, it is not powerful enough for me.)
The best experience I've had so far is with Tabs Outliner for Google Chrome and Chromium-based browsers. I find that it's UI requires the least amount of clicks and remains performant even when I have a thousand open tabs and hundreds of thousands of saved tabs. https://chrome.google.com/webstore/detail/tabs-outliner/eggk...
My two main gripes with Tabs Outliner is that it is not FOSS, and that it often forgets that I've purchased a license for Google Drive sync.
I have yearned for a FOSS alternative to Tabs Outliner. The best one I've tried so far is Tab Fern: https://cxw42.github.io/TabFern/
I love the Tab Fern concept and it would be my primary choice but for the following two issues. First and least consequential, the performance is close to but not 100% on par with Tabs Outliner. Second, you cannot open a single saved tab as with Tabs Outliner - instead it will open up the entire window. This is a headache to deal with when your Window has a lot of tabs (it's also a feature that's on the Tabs Fern roadmap.)
I badly wish there was a Tabs Outliner or Tabs Fern for Firefox. Perhaps architectural differences between Chrome and Firefox mean that it will never happen. In lieu of that, I've settled on Session Sync for Firefox: https://addons.mozilla.org/en-US/firefox/addon/session-sync/
Session Sync is pretty awesome, especially so because it's also FOSS. It can effectively manage the same amount of tabs as Tabs Outliner while avoiding both of the issues I've mentioned for TabFern. The main problem I have with Session Sync is that these things all require more clicks. For example, if you want to close a tab using either TabFern or Tabs Outliner, you can find the tab in the listing (presumably you searched for it to save time :) and there is an icon right there to close the tab. With Session Sync, you actually have to right-click on the tab before you are presented with the list of available options, which include a Delete option. While this is inconvenient, it's still perfectly workable, and it also has the benefit of slick import/export/backup/sync options that the other two are missing.
As for Skeema, the Chrome extension described in the article, I'd give it a try (if they accept my request for invitation) and would like to see if it could supplant either of the 3 alternatives I've mentioned.