A Little Goes A Long Way
There's no reason to fear a large tattoo. It's done in manageable sessions that are completely tolerable and therefor a smaller tattoo is no different from a large one in your ability to tolerate the pain. With that being said you must also think of your future tattoo, don't listen to people who say, "go big or go home" and don't cheat yourself of a better tattoo only because you might be apprehensive of its size and equating it to more pain. Pain is temporary and your tattoo is permanent. Follow your fear.