The Loch Ness Monster story alone is worth £41 million to the economy, but embracing the supernatural and fantastical is not without its drawbacks