The L322 is awesome as a vehcle...and on LPG makes sense.
Yes the Gearboxes are the biggest weakness of the L322, diesel's imparticular with the GM box.
I would suggest a post 2005/6 with the facelift as these had the much stronger and much more reliable ZF6HP26 box.
The ZF5HP24 is better than the GM box, but as I posted in a recent thread, the ZF5 is prone to a couple of failures, but aslong as it is caught early, can be resolved and at a cheaper price than the GM box.
If you are up to the task, it is possible to DIY repir the ZF box and in very broad terms the process is to drop the box, reomve torque convertor, remove oil pump, remove the Tower with A & B clutch packs, replace the roller bearing and O ring, put it all back together and with luck all is good.
Whilst the box is off, you can get an overhaul kit with all the O rings etc and the process is to strip the box, replace all the seals etc and put it back together again....not for the faint hearted, but no special tools are needed apart from 3 rings used to compress the clutch plates so the snap rings can be refitted if you are going to replace the friction plates.
Could be done in a week or 10 days or so, but you will need to be handy with the tools to do it, and you'll need a clean and dry workspace.
They are great cars to drive, exspensive to repair and daunting when they go wrong....