The Tavern of Kaspar's Amateur Sprites

[Leshrot]

Is there like some ultimate guide that shows exactly how the pixels should be placed and what contrast they should be if you want to create ___ type of texture?

There's many different styles and paths to do the same thing, there's no ultimate guide but a lot of practice.