You need to specify computer's hardware and allocated time or number of nodes. Latest SF at depth 3 or 1000 nodes will massively fail lots of tactics( SF rating level probably 1600-1700), meanwhile the same SF on 1 billion nodes( SF rating level approx 3500) will see 90-95% of most tactics positions.
In some difficult tactics, stockfish needs more than 1 trillion nodes( SF rating approx 3700+) to search to get the right answer, where we normally defined as Failed for Stockfish.
In my years, I've played thousands of games against a computer. One thing I've noticed, is that I've never been able to successfully use a tactic against a strong computer. Have you? Think about it.
Has there ever been a single incidence against a strong chess program where you were actually able to pull off a surprise move that the computer didn't see? For example: A Queen sacrifice that leads to a winning position. Or, a Rook sacrifice that actually works and tips the evaluation in your favor?
You haven't.
Reason why, is that the computer sees the tactic loooooong before you. Not only does it see the tactic several moves before you, but it can look much deeper into the position than you can. It also has a plan to trump your fancy tactic just in case you happen to try it. This, by the way, has happened to me many times where I thought my tactic was good....only to find out that the program had swift and effective responses to make the move awful.
There are no surprise moves against a computer. It's going to see those tactics and have plans to strike them down.
So if you're going to be winning against a chess program, tactics are not going to help you in the slightest. It's the long terms strategical ideas that seem to work best. For example, lock down the pawn chain and flag it's clock by playing faster. This seems to be the most popular method of winning against a program. Other ideas like having a 3:2 pawn majority on either side of the board might actually help you beat a program if you make it to the endgame.
The reason I mention all this, is that some new games have surfaced between Alpha Zero and Stockfish. Alpha Zero is playing so well, that it's actually finding tactics that Stockfish isn't seeing. And it's not that Stockfish isn't actually seeing the move, it's just not really taking the move seriously or not evaluating it deeply or effectively enough.
Alpha Zero plays Ng4 clearly offering the knight for a pawn. Stockfish looks at the move, evaluates it, takes the knight, and then only a few moves later realizes it has made a mistake. AZ is successfully executing tactics against SF. That's how strong it is.
Humans rarely, if ever, have that luxury against a strong program.