We use Costco Kirkland brand diapers all day and have no issues with leakage (unless he has a poopslosion). I haven't changed him at night since he was two months old -- they hold a ton of pee.
I could never find them smaller than a size 4, and they are only the Huggies Overnights. I would suggest using one size bigger than you are for the night time.
When I did some research on the difference between Pampers Baby Dry vs. Cruisers once Lindsey reached size 3 diapers, the Pampers website describes the Baby Dry as a nighttime diaper. Baby Dry's to me are great with pee...horrible with poop. Cruisers are more like Swaddlers, so we are just using those for both day and night right now (granted we are in size 4 already)
We put Max in the next size up for overnight... he's in 2s during the day, 2/3 at night. It's been working for the most part! He'll be in 2/3 full time as soon as we finish of the box of 2s we have.
Re: Overnight diapers in a size 2?
We were a Pampers1 family at that size. I either bumped up to the next size at night, or we had the Pampers Baby Dry for night time.