you have a dx with dpfi so any other engine you'd move to would require some wiring to make it mpfi like in a d16a6 motor...but for another auto tranny...keep the one you have and just replace the engine
i'd suggest converting over your car to a manual...which i hear is not too hard but i've never done it personally