The transmissions you mentioned...the 42LE, is a 41TE with a different diff and output. It was used in the LH platform. You know, the crazy setup on the LHS, Concorde,Intrepid,300M, etc. with the engine longitudinal yet it's still FWD. Though it was also used with the 2.7 in the intrepids(longitudinal mount) it wasn't used in the sebrings. The sebring has the 41TE with both the 2.4 and the 2.7 engines. So that transmission would fit in your van, if the mounts are the same...which they probably are, if anything the internals would. As for anything else, scrap it. Not much you can use for it for your van or the 300m save for maybe an alternator or something if it fits. The 2.7 is based on the 3.5 which is based on the 3.3. The 2.7 however is known for sludge issue's which is probably what caused the rod knock, from lack of oil circulation. It's probably toast. If you took a valve cover off, it'd more than likely be coated in peanut butter, depending on the mileage.
2013 Infiniti G37x 32,000 miles VQ37VHR; 1999 Nissan Altima GLE KA24DE 220,000 Miles
Prev. 97 T&C LXi 184k 3.8, 94 T&C 3.8 156k Miles, 93 GV LE 3.3 123k