I have an '89 Ciera with a good motor, but the transmission isn't shifting well. I have two Datsun 620 trucks, one with a Datsun automatic, the other has a manual trans. I'm rebuilding an L20B for the manual trans 620. I thought of swapping a KA24 (2.4 liter) in the auto trans 620 but most of the four cylinder motors that I come across in the salvage yard are worn out. The KA24 is rated at almost the same hp as the 3300, but the 3300 has better torque at lower RPM. The fuel economy of the 3300 is very good, as good as the four cylinder L-series Datsun ( when the axle gears are changed from the stock 4.36:1). The 3300 does not have balance shafts and has a 1-inch lower deck height than the 3800. There's nothing wrong with a 3300 when torque and economy is the goal.
The only issue I heard with a Buick 3.8 V6 in the Datsun truck is the GM automatic transmission yoke can interfere with the truck rear torsion bar mounts. The GM automatics, Turbo 350, 200R4 etc, are 2 inch longer than the Datsun transmission. The Speedway "metric" transmission adapter can allow these auto transmissions to attach to the 3300, I don't know which torque converter must be used. To resolve the clearance issue you can grind away part of the rear yoke(which I don't want to do), or remove the torsion bars and use an air bagged suspension, which can help the truck handle like a sports car.
Another option is a manual transmission but I don't know which flywheel might work with the 3300. I don't think there are many options for the flywheel, although there are "metric" manual transmissions that can attach to the 3300 without an adapter, eg a T5 from an S-10 truck.