I'm sure it is painful and dogs learn quickly to avoid things that have caused them pain so he may try to avoid that door in the future.
Some breeds have their tails cropped as puppies and I've never seen any evidence that it makes them neurotic. He will probably wag his butt as if there was a tail there and go on with his life. Unlike humans, dogs don't expect much so they're seldom disappointed.