Every single game should have story mode coop as an option, including stealth and horror games. It is selfish to try to keep it out of games just because you don't care for it when it is kept entirely to being an option.
The only time it becomes an actual issue is when the game is built in a way that it requires a single person to use an AI partner ala recent resident evil games but that is the fault of a stupid development choice not because coop existed in the game.
There is not a single game I wouldn't get more enjoyment out of doing the story with a friend, but because barely any games have story mode coop I can barely ever enjoy that whereas people wanting to play single player have that option for practically every single game with a story campaign.