Many a times name tattoos are the result of some suffering, loss or angst and provide a lot of solace to the person getting it done. That is why many people have the name of a partner or a child that they have lost tattooed on their person. This is one of the tangible ways of offering homage and honoring their memory.
With name tattoos being intensely and immensely personal there is no ideal way to go about it. It is all about where you want, what you want and what other elements you want it with.