There are a few neat technical advantages to running a V6. The biggest one though is that it essentially places the entire engine behind the front axle centerline, making it a front/mid engine like an Infiniti G35 or a Citroen DS. However, there are some things that will make this a VERY hard swap to do, and all of them have to do with engine management. With an older design, you could just run a stand alone ECU like a Megasquirt. Not so with the DI V6. Why? Well, it has to do with managing a direct injection system. DI engines have a fuel system that has more in common with a modern common rail diesel than the EFI engines of old. The fuel pressure is VERY high, like over 1,000 PSI high. It relies on being able to use those high pressures to very quickly inject the fuel into the chamber right before the moment of ignition, and not in the intake port air stream like in older designs. It is a much more efficient system than the old engines and produces improvements in power delivery and fuel economy that were not possible in older designs. However, no one has cracked it yet insofar as swapping goes. I was actually reading a build of a Chevette with the DI turbo 4 from a Solstice GXP being swapped in, and the guy could not get it to work. Remember that on a modern car, the computer controls damn near everything to allow for ultimate optimization. While this is good on a new car, it is a nightmare for swapping. Why not just eliminate those things? Well, for starters, the computer expects them to be there, and won't play nice if it does not find them. The Camaro uses an E throttle (like a Toyota with unintended acceleration) as part of an elaborate traction control and electronic brake force distribution scheme. If it fails to find the factory brakes, it is likely that it will not run above idle. So.... do I like the idea? Yes. Would I attempt it? No. If it was my $25k, I would just buy a new V6 Camaro instead. It will be a better idea in the long run.
Oh, and as far as being a bolt in.... No. In no way will it come close to bolting to the stock mounts, transmission, accessories, etc. in a G body,