VQ30DE-Ks are pretty solid and they respond well to boost. They've got high rod to stroke ratio meaning the rod is at less of an angle with the crank and won't stress the bearings as much.
It's only the early 02-03 VQ35s that burn oil.
On the 4th and 5th gen Maxs, the lower radiator support will rust out where the lower engine cross-member bolts to and it'll rip out eventually. It's not really a matter of if, it's when. It's a pretty big job.
Wheel bearings on these are kind of a pain since they're pressed in.
The rear calipers lock up prematurely.
But otherwise, these cars really aren't that hard to work on.
I would personally find a 02-03 car with a blown motor and swap in a 07+ Altima or 09+ Maxima VQ35. These engines had HR head castings, more aggressive cams, and a more free flowing upper intake. There are threads and info on how to make those work on maxima.org. The 09+ Max engine has been pushed over 300whp n/a on stock cams. The Alti engine is basically an 09 Max engine but with static exhaust cam timing.