Launch vehicles are not the same as spacecraft. The best launch vehicle profile is the one you always see, minimal frontal area with maximum volume - cylindrical with a pointy end. Not exactly irrelevant since the launch vehicle is often the single largest expense in the project.
I'd say the ideal shape for a spacecraft - in space - is the most functional one.
On a completely seperate topic, dimpling versus smoothness for aerodynamics has been discussed here and elsewhere repeatedly, a simple search followed by some reading should answer your question.