You can't avoid bottlenecks. They are an inherent side effect of a PC being made up of multiple parts, and performance not being infinite. There will always be a slowest link in the chain, and since loads are not static and identical, you can't define a particular part as the constant bottleneck.
Instead of worrying about bottlenecks, worry about "am I satisfied with the current level of performance". If the answer is yes, then no action is needed. If the answer is no, then you ask "where do I want more performance", and then you analyze what part is the limiting factor in that situation, and upgrade that part.
My merely personal rough rule of thumb is this. For those already on AM4, moving to AM5 doesn't make much sense yet (Zen 6 may be when this changes more) unless you're going to one of the most performant CPUs on the platform (read as, Ryzen 9 x950 or any of the X3Ds). Why? It's because the vanilla Zen 4 and Zen 5 CPUs don't really outperform (in gaming, anyway) the options you have on AM4 by enough (if any!) to warrant changing the motherboard, RAM, and CPU... instead of just the CPU (read as, 5700X3D).
I think a Zen 3 CPU is fine for an RTX 4070/Super as well, but that's your decision to make, not mine.
Personally, if I was to make any change with that hardware, it would be the SSD. The Crucial BX500 is a low end SATA SSD without DRAM, and you really want your OS on something more performant (if it's SATA, you want DRAM, but you may as well move to NVMe, and you could carry it forward through future changes so it's not a waste either). The current one is not terrible... but if I had money to burn, that's the first place I'd look.
The RAM is also a bit slow, but not bad enough that I'd replace it. If anything, that lends credence to a 5700X3D change being worthwhile. The X3D CPUs care less about slower RAM, whereas the vanilla models incur a bit more of a performance loss.