In my experience the connotations are as Faldage implied always derogatory. Whether you take the context to be an early quadruped advancing in estate to rise on its hind legs, or a cat or dog springing up to fight with front paws extended as they do, the implication remains the same: only a less cerebrally advanced form of life has hind legs.