You made the mistake of making me talk about Total War games and my experience with them, I am obsessed about them because I have been researching benchmarks and making tests several times 😉
Most Total War games are CPU demanding and GPU demanding at the same time so you can easily have 2 bottlenecks. RAM is not an issue because with 16 GB DDR4 2000 MHz is more than enough, hard drive is recommended to have SSD because the loading times can be an issue but the most problematic hardware with Total War games are CPU and GPU. Some Total War games are not CPU "optimized", you can read complains about that almost everywhere. For example, games that are not multicore supported are Medieval 2 and Empire. Since I usually play Empire Total War, which is a game of 2009, I made some tests and I discovered that this game only uses 2 cores! well, not even 2 cores, the game engine fully uses 1 core and try to support the load of the first core using a second one up to 70% of load. As a result, CPU is bottlenecking GPU with not so big armies. Fortunately, this is not longer the case of other Total War games, but in some extent, this is an issue of almost every Total War game up to Attila Total War (2015) included, and seems that was fixed in Thrones of Britannia (2018). For a game such as Empire Total War, which is one of the most problematic of the saga, you have the case where a GPU Nvidia GTX 970/980 is more than capable to run this game at max with very high FPs but the problem is the CPU that will bottleneck the GPU because regardless the CPU, the game engine will only use 2 cores. For Total War games, it is said that more cores doesn't help at all, because the game engine will not use them anyway, but latest Total War games at least use 4 cores and if velocityg4 is right, Three Kingdoms, the latest one, uses 6 cores which is an amazing improvement. So, in Total War games from Empire (2009) to Attila (2015) the most demanding hardware is CPU because of optimization but also from Rome 2 (2013) to the latest one Three Kingdoms (2019) GPU is also big demanding and you need top gaming GPUs. Attila is the worst optimized game of the saga, because inherit the CPU problems of Empire + needs a monster GPU (even considering that is a game from 2015, even current RTX cards may struggle). Also Total War games, as far as I know, don't support SLI.
All of this is just to say that I don't want to have huge armies, but at least a CPU that can run the games with decent armies without "dramatic" fps drops. So, if Total War games are limited by the use of cores (except Three Kingdoms), what is the key to have a good CPU performance?