Is it at Miami or in Miami?

It can be either depending on structure of the sentence but 'in' is more commonly used.

EX: The plane landed in Miami.

The game was held at Miami's new stadium.