Or does it work on the supermarkets and gas station too?

Most places I buy from are chains like that.

Considering your experience there, there's any chance you got merchants showing you a P2P lightning invoice directly?

Almost all of the places use third party services. They verify my transaction has gone through by checking their systems for confirmation. Pretty sure the lightning level is abstracted away completely from their perspective.