Failover and the like is generally a feature only prosumers and enterprises want or need. So most consumer routers do not support this espacially the cut down crap most ISPs give you.
You can either get a high end consumer router or build a opensense box with 2 WAN ports. Here you can hook up both Internet connections and select how they should be used.
Note that this might mess with forwarded ports and the like as your WAN IP will change on switch over.