It’s great - if you have a good boss.

Unlimited cons: need approval, don’t get paid for unused time when you leave
Limited cons: needs approval, some places have use it or lose it policy for each year or you need to wait for days to accrue, limited sick days

Unlimited pros: unlimited, usually comes with unlimited sick days, don’t have to worry about accruing days
Limited pros: get paid for unused days when you leave