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.