Does the two input aspect mean I could use it both in front of the amp AND in the FX loop?

Yes, but this may create ground loops in some set-ups which will cause an unpleasant hum.