Apt, more often than not, acts as a gatekeeper for the latest version of whatever software packages I'm trying to install. I end up just having to adding various libraries and repos to my sources list to get the version I need, or go to an outside dependency manager like gvm, sdkman, etc which is basically homebrew anyway.
Homebrew is for devs that need to get shit done, apt is for computer scientists that love the tool more than solving problems with a tool. For the record, I'm on both linux and mac and there's plenty of upside and downside to both.