It looks like the generation digit corresponds to year for Desktop CPUs too. I think the only major difference from the image I showed prior is the last digit, the desktop CPUs have different letter(s) but the other 4 digits correspond the same. For example, the 7950X is 2023, Ryzen 9, Zen 5, Lower model, and X is high power draw and clock speeds, then there is the 7955WX which is 2023, Ryzen 9, Zen 5, Upper Model (Threadripper), Workstation. The 8950X upcomming cpu is 2024, Ryzen 9, Zen5, Lower Model, High Power and clock speeds, etc. So the 8 series is still Zen 5, so its still a refresh of other zen5 chips, however it also apparently has about a 20% uplift compared to the 7 series, but its still a refresh. So the 9000 series we won’t know if its a refresh or not until we have the skus with the 3rd digit, if its a 6, then its a not a zen5 refresh, if its a 5, it is a zen5 refresh.
I use https://www.amazon.com/dp/B09TB83NR2?ref=emc_s_m_5_i_atc and I just don’t use the wifi, everything can be done on device or from a PC you plug the SD card into. I know you said you want it without wifi, but without more details I don’t know if “without wifi” is a necessity or if it just is fully functional without using “wifi” is sufficient for your needs. By default wifi is disabled while the camera has power to it and is recording, and its wifi enabled/disabled state can be changed in the menu to keep it off.