Payment standard does not use a failure page.
The transaction with paypal standard is not processed real time. The checkout success page really only means that paypal has accepted the payment method and placed the transaction in a queue to process on a first come first served basis.
The cancel URL is used if the customer hits the cancel button on paypals site.