-1 Card is pretty nice as attacks go. If they are not drawing, it is a Minion a turn delayed. This is really handy on a money board as it drastically reduces the odds of double Gold or Gold/ Silver x; many copper based $8s just die. Likewise money boards have few competitive cards after you have a few terminal $5, so you may as well buy Raid instead of yet another Silver; the -1 card making it superior to Duchy for a decent while whenever you gain one or two Silvers off it.
If they are drawing, it can appreciably lower the odds of kicking off an engine, particularly ones like Village/Oracle where the village draw is needed to have good odds of hitting an Oracle. It is about the only "discard" that actually makes a dent in Minion setups (much harder to chain if you need .33 Minions/non-draw card than .25). With zero Silver gain, it still be worth it (e.g. as a last ditch, stop their Minion engine for a turn so I can double province again next turn)
This attack also means that it allows you to go money against a number of marginal engines that Masterpiece might struggle against. But even in engines Raid can be good. If you have the draw it is one of the faster scaling means of building value. Each turn you can literally double your buying power so $6 -> $12 is a single buy, better than Plat for cost efficiency. Now for some setups, draw is no object (e.g. Chouse/Cellar engines with top deck control, some Madman decks) so you can do some crazy things - like Raid/Mission/Raid and then having $40 to play. But a number of engines can manage a lot of draw with a Silver flood.
One I like is Storyteller. If you can consistently play 3 Silvers with Storyteller, then she gives you +7 cards at the cost of 4. This is Hgrounds/Village or 3 Labs territory. Normally, it takes a lot to add another high silver Steller to your deck ($14 if you want to buy everything) ... but Raid is great here, you pay $10 to setup a second Steller (and gain the attack) or $15 for two. Even your whiffed turns are province buys (Steller being, at worst, cantrip). Raid/Steller is one of the few times where massing the latter can actually be viable (all you really need are +buy and trashing).
Outside of gaining large numbers of Silvers for coin, just using Raid as value gain or card count gain can work. Getting two or three Silvers each turn to feed your Upgrades is decently buy/cost efficient. Feeding two Silvers each turn to a Merc is also not a bad go for netting $1 and leaving them with 3 cards -1 draw. Very few things in Dominion have the ability to gain the number of cards that Raid can and very few things can gain close to the total value (e.g. gain 3S, Forge to Plat each turn).