When I use my vanilla cake recipe I generally have enough batter left over for cupcakes.  Why is the texture more fluffier and moister than the actual cake? The cake itself is not dry at all but dense.

I don’t know the specifics of your recipe, but perhaps the smaller pan size is the reason.  Cakes without a strong structure generally do better in smaller pans.