I’ve been trying to find this old PSX game where you do these missions (e.g. go inside the hotel room and kill off the people/mercs inside)
I think it involved some stealth.
Missions are contained.
iirc there’s a sequence of actions you should do (doesn’t have to be perfect) to complete the mission.
setting: within a moder city
you use guns as main weapon.
Might be a very obvious one but… Splinter Cell?