Someone's fursona is an expression of the self -- often a truer expression than the flesh, honestly. The tail should be whatever size feels right, be it 3 inches or 30 feet.

But if you're asking about our own fursona? We wouldn't mind a reasonably-sized tail (probably about 1/3 our height, proportionally) to whip around as the need arises.