The little hole is about .030 depending on the brand of nipple you buy.
While that sounds small, the reason Old Charlie mentioned is the key.
If the hole is too large, the chamber pressures can blow back up thru the nipple and raise the hammer.
Even at .030, most guns hammers raise a little, but if the hole has been drilled out it can be so bad it will blow the hammer back to half **** (or further).
This isn't good for the lock, and it can ruin the guns accuracy.
IMO, a undamaged nipple with a #11 cap should fire a properly loaded gun 99% of the time if it's shooting black powder.
If it is shooting Pyrodex or the other black powder substitutes, it should be at least 95% reliable.
Of course, a lot of this reliability depends on the caps your shooting.
If they are old, off the wall brand (I have some that I don't even know who made them. The can says "Made in Italy") you can't expect them to work very well.
I know others will not agree, but I think CCI standard and Remingtons are good, and about equal to each other.
RWS 1075s are noticably more powerful and CCI Magnum is about the most powerful.