Welcome. Here you will see ships designed as well for efficiency and aesthetics.
Mods will often be used because KSP stock parts' artworks are not great: Recolor Depot or Restock(+).
Many materials have been uploaded in my community repository on Github: github.com/OnlyLightMatters/CommunityMaterials