This. It can be used more colloquially than the equivalent meaning of "terrible," where it's closer to something like "awesome." It can also generally used as a marker of intensity. In no case does it mean "bad at something."