I would go tool around clubfrontier.org for a while. I only know 1 member here that has a new Fronty. I do think they look the best of all the new trucks, and they have some pretty cool colors too.
They had a parking pawl recall - its a Mercedes designed transmission that Nissan builds. The parking Pawl was a machining problem, and I only heard of a couple owners that actually had any issue, so who knows, but that is long behind them. I haven't heard of any other recurring problem, just the occasional one off issues - like the frame weld mentioned which is un-nerving for sure.
The previous generation was wildly reliable, but it took Nissan several years to get through there issue - seems to be normal for them. This particular engine / transmission has been in service since 2020 - they put it in the old body style for a couple years. So its still pretty new. Nissan electronics tend to be pretty good mainly because they use Hitachi/Denso/NTK for everything. The rest of the truck is actually very close in design to the earlier truck, so likely no issues there.
If I had to buy a new truck I would likely get a Nissan. Myself, I would be more likely to go looking for a gently used second generation that still had the VQ40 - with MPI only.