Any character upgraded to a higher "rarity" will ultimately have less stats than a trained and leveled character that's naturally that rarity. That said, it's still generally worth it, especially depending on what character and variant you're doing it to.