I don't think that's a fair comparison. I think Curie is closer to Serana than Piper, but that still isn't a fair comparison. Serana is weaved into the entire plot of Dawnguard. Piper and every other companion (with maybe the exception of Paladin Danse) is kind of just there for the ride.