Well since you are talking about Sierra, I would love to see a revival of Swat. Perfect time for Swat 5 and I know ready or not basically is swat 5 but having a AAA studio backing may be fun. Then again with how monetization is in AAA games, this may just be a cursed wish.
I think if you miss tactical shooters. I think it is worthy to give a shot. The classic R6 games had a similar feeling. I think the only drawback is since you are using cop style weapons you aren't going to have as an exotic arsenal most of the Assault rifles in the game are AR platforms, you get 1 SA-58 (FAL), 1 Ak platform, and a g36. The Smgs are a bit more diverse. I also think there were some fans who were remaking some maps from Ravenshield.