"what if I just had a better system with no downsides or logistical costs that was also cheaper".

In reality: Ukraine reliably downs Shaheds using a mix of low cost technologies.

They mostly can't defend against ballistic missiles without high cost interceptors.

The Shaheds could do a lot of damage to the Patriot site if they could hit it...but they never get anywhere near it. That's the point: your low cost system does not have the capability to threaten the high cost one.

And in all this you've forgotten that attacking the SAM site is only being done to enable other operational objectives. The Patriot battery is defending targets many times it's value, including the logistics and launch sites of all those low cost defensive systems - or the logistics and launch sites of your own low cost offensive systems.

To the article: the Tomahawk missile costs about $2 million per shot. Assuming this article is true, the missile in question gives you maybe a 20:1 cost advantage...but can it do the same mission? Does it have the same range, or targeting, or precision? If you cannot fire these from the same range as a tomahawk, or they don't realiably hit targets, then they can be substantially worse for a much higher logistics cost to deploy (perhaps total: the truck blowing up because you had to drive it to the front line is rather a problem).