Can you check in a hotel with a Mexican passport?

Yes, of course. Foreigners are expected to use their passports when checking into a US hotel.