Mesoscopic effects and local negative superfluid densities