Goldenseal is one of a handful of herbs that contain a yellow alkaloid called berberine.
There has been a lot of research done on the value of berberine which you can read about in The Amazing Benefits of Berberine.
Berberine is an antibacterial and antifungal agent and herbs that contain this bright yellow alkaloid have been used around the world to treat infections. They've also been used to make yellow dyes.
Back in the 1980s and 90s, one of the most popular herbal duos in the marketplace was goldenseal and echinacea. This combination was used as an antibiotic alternative and I found it valuable for sinus and urinary tract infections.
While it's still a powerful combination, because of its scarcity most everyone uses Oregon grape or other herbs with berberine in place of goldenseal.
These alternatives are great substitutes that work just as well in most cases.
But, one particular infection I would still use goldenseal for is amebic dysentery (giardia). The plant is officially recognized as a remedy for this parasitic infection in several countries. It's the most common cause of diarrhea from drinking contaminated water. A good way to use goldenseal for this purpose would be to take two capsules of goldenseal or 60 drops of a tincture or extract along with one capsule of activated charcoal every four hours until symptoms cease.