I’m a native speaker, and I prefer “at”. I think I’ve also heard “in”, but “at” sounds better to me. It might depend on the region, though?

in" used when the phrase is followed by verb, whereas  'at' is used when the phrase is followed by a noun.☺️

I'm Good in sports is correct

Both similar meaning - At sport refer usually to one sport

I’m good at sports