In order to make use of anaerobic bacteria, the filter (sump, whatever) would need to have an anoxic zone. This would be an area where water movement is "so slow" (almost dead) where these anaerobes, or facultative anaerobes could thrive, in an nearly oxygen free environment. These dead zones often create hydrogen sulfide pockets, that when released as bubbles, smell like rotten eggs, and if there is enough of it, can be deadly to sensitive fish.
Not a desirable idea inside a house.
This is not the common, in aquariums, so what these bio additives do instead, is provide food (enzymes etc) that promote aerobic organisms ( bacteria, rotifers etc) that compete with less desirable organisms.
Rotifers need plenty of oxygen, as well as the bacteria we want, why filter turnover rates are kept high.
Back in the 90s, plenums were causing a stir, they were anoxic areas under a deep sand bed substrate with little to no water movement, I experimented with them, but because I kept cichlids that dig, I could not maintain that anoxic area. They were mostly used for nitrate reduction in salt water tanks, that were expensive to do water changes on, kind over over kill in freshwater tanks, that are easy and cheap to do water changes on.