"Hand painted" not always literally mean that texture was drawn by hand. This term used to categorize art style in most cases. Such a texture can be easily generated from highpoly mesh in Substance Designer or Quixel.
The simplest shader you can use for hand painted material style is unlit.