what actually works to get rid of ants in the house quickly?

Bait, not spray. It feels slower, but they carry it back and it takes out the nest, which spray never reaches. Put the bait stations right on the trail and don't spray or wipe near them or they'll avoid it. You'll see more ants for a day or two, then they drop off. If they ignore a sweet bait, try a protein or grease one, colonies switch what they're after.