i wonder if we can achieve this level of visuals in unity?
Anything is possible with Unity, but the question is if you are capable of working it to your needs.
In this case, it looks like all you need is a really, insanely high-res bump and specular map. Wouldn’t even need a custom shader.
Wouldn’t even need a custom shader. what do you mean?
Stylized and faint reflection Cubemap and a highly tiled normal map made up of random noise would probably do the trick.
This cannot be achieved with a built in shader, it requires a fresnel ramp for the reflective shader!
http://developer.download.nvidia.com/shaderlibrary/webpages/hlsl_shaders.html
Car paint shader might work.
Is the effect that when you rotate the object you get different color highlights? You can probably simulate this by tweaking the gold flakes parameter in the shader. These simulate small particles embedded in the paint to give it different color highlights.
Also you can try brdf shading. Based on how the light and view vector are it looks up the correct color on a texture. The hard part is producing these textures.