A goose neck pipe can not be bought. It is just a straight piece of electrical conduit when it starts. It is an electrician with a conduit bender or a hickey that bends the conduit into a goose neck configuration.
Depending on the type of drain pipe referred to, "Yes", it can have too much drop or "fall". Specifically sewer drains, as too much drop allows the liquids to leave the solid material behind, causing...