Yeah the new Nissan Leaf looked horrible as a concept car, very "2003 idea of the future". The actual production version is just a boring SUV
As an exception to this rule, the original Audi TT was surprisingly similar to the concept car and even the initial concept sketches. They had a crazy design idea and just went with it.