There is a great book called "The Best Move" by Vlastimir Hort and Vlastimir Jansa that provided diagrams but often didn't tell you who was winning.
Unfortunately, a reprinted edition is reportedly of low quality.
Here is a page copied from the Internet Archive copy of the original 1980 version of the book:

I love tactics. I do tactics everyday. However, I struggle to use them in game because I never focus to find tactics as I do while training.
I think a good solution could be to have an app that proposes puzzles, but that includes some puzzles that do not have a specific winning move (like a sacrifice, winning a piece).
Because the only problem with tactic puzzle is that you know what you are looking for. Whereas in game, its also about strategy/improving pieces..
Do you know a platform that can do that ?