Games with Good Campaigns?

Been looking to get back into cod on pc. I mainly want it for the campaign but i also enjoy modding games and the zombie modes from BO1+2. I haven’t played much COD in the last couple years (last 5-6 years). I have played some of the newer titles but just like once or twice every couple months because they are on my roommates xbox (I wouldn’t know which ones or much about them since i only played a couple matches of multiplayer each time) I’m going to wait for sales but what games would you folks recommend most for me?