They'll have different roles or specialties in combat, but they won't necessarily have any direct drawbacks. All of your stats will increase, but depending on which Sin you pick they'll scale differently (Wrath will get a higher Attack boost than the others, Gluttony will get more health, etc). They'll each come with unique skills as well.