It's not visual noise to me. I currently have:
* 7 Brave (personal) windows with ~3-5 tabs each
* 6 Chrome (work) windows with ~3-5 tabs each
All of these windows relate to different things. For example whenever I check HN I fire up a new window. I might not have 2 hours of time to read/research everything interesting I happen to find so I just leave that window open for later.
Whenever troubleshooting I do the same as you, a window can get up to 20 or something tabs, but once the problem is solved those get closed. Or if there are interesting tabs in there that warrant future research, they get grouped in a new window.
On Mac I Cmd+tab through apps and Option+tab through windows of a specific app (don't remember what the default combo is). Or I swipe three fingers down to see all app windows. And I also use Tab Switcher[0], which allows me to Cmd+Shift+K to fuzzy search all open tabs.
This setup is not optimal, but it's not that messy/problematic for me.
[0] http://flowapps.co/tabswitcher/