From 'overhyped' Brighton and 'commercial' Windermere, these are the UK's biggest tourist traps - as travel expert reveals the hidden gems worth your money instead