The other big problem is that if it's big enough, it may be uncomfortable or down right painful for any partner.

Again, that's usually more of a girth than a length problem, though too much length can also result in pain. (Bumping into the cervix is, for most women, a rather painful experience.)