Hello all --
Some bumblebee gobies are not only freshwater fish in the wild, but blackwater fish too, living in places with acidic, tannin-stained water. I'm not sure why such conditions aren't ideal in home aquaria, but I'd venture to suggest diet and water quality (esp. nitrates) are relevant here. There are some freshwater fish that do poorly in freshwater because they are nitrate-intolerant, but thrive in brackish water, because the salt reduces the toxicity of nitrate. Mollies, for example.
In the general community aquarium adding gobies is debateable. Your problem isn't necessarily water conditions or chemistry, but rather feeding. A lot of gobies are slow feeders, and things like guppies and cories will simply take all the food before the gobies get a chance. Personally, I'd tend to recommend only keeping gobies in community tanks with fishes that feed at different levels of the water, or feed very slowly, or on totally different foods. So gobies could be mixed with surface feeders (e.g. hatchetfish), slow feeders (e.g. Badis badis), or wood-eaters (e.g. clown Panaque).
My gut feeling is that even if the bumblebee gobies didn't get eaten by the knifefish or stressed by the freshwater, they'd still die from starvation.
There are some nice mid to large sized freshwater sleeper gobies that can work very well with plecs. These are predatory fish and will simply eat the livebearers and the tetras, but they are fine with anything of similar size. Oxyeleotris marmorata is one example.
Cheers, Neale