I'm currently on a 6700k and looking to jump to Alder Lake. I was all set for jumping to a 5900/5950x setup but it doesn't seem worth buying into AM4, especially when I keep things for 5/6 years.
I have a 3080 and a 38" ultrawide so want to get the most out of that (although things run pretty well tbh!) but I also dabble in 3D rendering at times so wouldn't mind the most cores for the money.
Looking at a 12900K but not liking the DDR4/DDR5 choice. What are people leaning to? I like the idea of not needing to OC (at least for now anyway) and don't mind spending a little bit more for longevity. Is there a go-to setup or things coming to hold out for?
It's not really a great time to upgrade and I definitely wouldn't drop money either on a 12900k or ddr5 for that matter, because your CPU should be enough to tide you over till Meteor Lake.
However if you feel you want something better you can go two ways: as above, Alder Lake has insane value at the low end, so a 12400, which is a bloody damn fast 6-core beast, with a solid b660 board is going to serve you really well. The second option if you want more grunt for productivity: grab a ddr4 z690 board of your choice, drop in a 12700k(f) and ride it to the ground for as long as possible. Only switch platforms when ddr5 becomes commonplace and intel moves to a new node. Should be enough grunt to skip even Meteor Lake. That's what I'm planning to do, switched from 4790k.
Don't overspend on the fancier z690 boards, ridiculously overpriced. MSI Z690A is the best value, also Gigabyte Gaming X but I've heard bad things about bios and memory compatibility. Asus TUF or MSI Tomahawk if you want something better looking and can get a good price. Z690A is not exactly a looker, mine also somehow has Foxconn ILM which is allegedly worse than Lotes, doesn't instill me with confidence given the bending issue happening on some boards. Thankfully, I'm on AIO now and mine has a hefty metal backplate which I installed before socketing the CPU, that allegedly helps.
Z690 gives you some wiggle room for OC if you want but bear in mind those chips are clocked pretty damn high and you won't get that much out of them, except much more heat. Personally, in your case I'd go with a good quality b660 and a 12700 non-k since you're not to fussed about OC, you'll save some money, get very close performance and still have 8 p-cores for productivity.