Soap bubbles are never "too small" or "too large". What defines the range of possible diameters of a soap bubble?
At the lower limit, if the bubble is very small the pressure inside will be so large that the gas inside can dissolve into the shell of the bubble, and from there diffuse out to the atmosphere. That limits the life time of small bubbles.
On the large side, huge bubbles (several meters diameter) are certainly possible. These tend to be unstable because they require extremely low surface tension, and thus they don't "keep their shape" very well. Over time they evaporate, or the soap molecules migrate causing an uneven distribution of surface tension along the surface. With insufficient surface tension in some places the bubble will once again burst.
In the absence of evaporation and instability, the ultimate size limit of a bubble may have to do with gravity: the film somehow needs to support the "column of soap bubble" above it, and if you think about hanging a soap film from a thread, you can see that it would be thinner at the top (which is supporting more weight) and thicker at the bottom. There will be a limit beyond which the film cannot support its own weight - I don't know how to compute it.
I don't know what you define as too large, but soap bubbles can reach very large sizes.
It's a balance between the surface tension being weak enough to allow the film to stretch to large size but strong enough to not tear as it flexes. The soap added to water is for weakening the surface tension.