Hmm. It would be rather something like "Heh, c'est trop cool ! ça déchire trop !" etc.
"le pied" applies mostly to the situations when one experiences a strong pleasure; the classic expression is "prendre son pied" which traces back to the XIXth century where it meant receiving her/his own share of pleasure during a sexual act
-- Andy