First off, sorry if this is a dumb question.
For some context, my brother and I enjoy playing tactical shooters with stealth elements, like Ghost Recon Breakpoint.
In Breakpoint, we have noticed that if one of us triggers an alert, it immediately reveals both of our locations to all enemies in the area, even if only one of us was spotted.
Are there any games preferably tactical shooters that don’t do this and are actually worth playing?
Army of Two features a unique mechanic where one player draws all the attention from enemies while the other sneaks around behind enemy lines.
The aggro mechanism is fantastic.
Very simple to determine who had the heat because one would almost instantly catch fire, and the other would appear almost translucent, making them appear to be ghosts.
This game was a blast, 
I believe a well-made sequel would be a great fit for today’s gaming scene. Streamers would definitely love it.
Baldur’s Gate 3 has a similar mechanic, depending on what you get caught doing, only the character who was caught faces the consequences. However, if your actions turn an entire faction against you, it can still impact the other characters.
I know you mainly asked about shooters, but this was the first thing that came to mind.
No, you are fine, to be honest, we also play Baldur’s Gate. Me as a Gloomstalker Ranger, and him as a Paladin.