the War of 1812 ended in complete failure for the USA.

Not really. There were half-assed gang squirmishes across the border but in the end, both borders remained exactly the same and historians agree no one won anything.