You may have difficulties with the choice of a CPU, you will solve them by looking at comprehensive benchmark AMD EPYC 9454 Cinebench r23 score single and multi core and decide how powerful is this CPU, is it a good CPU or a bad one to buy. Here you can find useful information from Cinebench r23 benchmark. A thorough review of all the specifications, so that it can be easier to understand, is presented in the form of the table. After looking at the data of all test and video, you already be able to figure out do you need to buy AMD EPYC 9454 or not.
The summary data in the article above do not mean that taking them into account you should totally trust a simple quantitative comparison. Better to watch benchmarks video and read the opinion of of people who bought AMD EPYC 9454 before deciding buy this CPU or not.