I love the images of the Hong Kong streets that are just seas of neon and flashing lights. And walking through does give a sense of excitement for no real reason that fireworks also makes us happy.
I think there is scope for banning of large scale ads in certain locations. When you walk through a tourist town that is, for want of a better word 'quaint' because of old buildings or similar, it's nice when they restrict the erection of modern advertising.
I think it's a case of horses for courses. In some places it works well, in others, not necessary. As long as the residents of the location can decide which way they want to go, I don't see an issue.