Thinkpad buying advice

Looking to buy a thinkpad for personal use. Am a heavy excel user (financial modelling) but that’s the main push I will have for the laptop, aside from standard shopping/netflix/etc.

Question is what laptop is best to buy? I’ve read some articles that the gen 4 is better than the gen 5 for AMD but then not sure what to get re. gen 6 with the snapdragon processor. I’m self funding, but not too sensitive to price but also would like to get a decent bang for buck, hence not looking at an X1.

I’m not too concerned about battery life either as it’ll spend 80% of the time plugged in and connected to a few screens.

Any help would be appreciated.