End-to-end distance distributions and asymptotic behaviour of self-avoiding walks in two and three dimensions