This depends on your needs.

The longer the cable the more versatile you can be in charging, for example with a 15 metre cable if someone is parked in a charging bay you can park in another bay and still charge.

The shorter the cable the less weight to carry and space to lose in your vehicle.