Used to accentuate the awesomeness of something. If something is beyond fantastic and needs more emphasis.
Can be used in sarcastic tone to mean the opposite.
Other versions: fan-fricken-tastic; fan-fuckin-tastic
Would you like to join me at the sold out concert? That would be fanfrickentastic!
Great, I lost my damn keys again, fanfrickentastic!