Origin of transition disk cavities: Pebble-accreting protoplanets vs super-Jupiters