Q: If the person before me plays a Hand or Keeper Limit card as the last card in their turn, is it instantly my turn, so I can ignore the Hand Limit?

A: Until everyone observes the Limit Rule as the last play, that turn is not over, so no, you do not get a pass on the Hand Limit just because it was played as the last card of the person before you.