largely depends on what species are already present in your tank. every tank is different with regards to livestock, filtration, etc. and the same goes for its microbial community (on the rock as well as the sand, biofilter, etc.). this can change over time; a species that eventually flourishes in one system might die off completely in another. this goes for both good and bad types. in some cases, adding certain species of microbes can definitely improve certain aspects of a system.
a lot of hobbyists only consider nitrification, maybe denitrification. but some bacteria are used to digest sludge, others are used as probiotics, others are used as food, and so on. i think a large part of the skepticism in the hobby over bottled products comes (and rightly so, in my opinion) from the fact that so many manufacturers refuse to disclose critical info such as the species of bacteria they contain. maybe if they did so, we could more specifically target particular issues with specific species and even specific strains of microbes.
it's exciting (to me, anyway) that folks like aquabiomics are analyzing the microbial consortia of the phenomenal tanks, comparing them to those of the not-so-phenomenal tanks, and giving us more insight as to what we should actually be aiming for. just my 2¢...