A properly Rebuilt A4LD will be better than 1994 factory A4LD because of the upgrades available now
Read here:
https://www.therangerstation.com/tech_library/a4ld.shtml
The rotating part of these transmissions was the same from 1985 to 2011, Ford just added more solenoids to the valve bodies in 1995 and then 2 extra external sensors in 2001
So a 26 year run, it was a reliable transmission IF.............rebuilt properly
Most trans shops had never seen an OD transmission back in the 1980's and early 1990's so didn't really have a clue on how to rebuild them, so.................."it was a bad design" would be their reaction when their rebuilds only lasted a year, lol
"A poor workman blames his tools", has always been that way and always will be that way, so avoid "poor workmen"
Your best manual swap will be a M5OD-R1(M5R1) transmission from a 1988-1997 2.3l 2WD Ranger, or 1994-1997 Mazda B2300
(2001-2011 Ranger 2.3l was a different engine so can't be used on your 1994 2.3l)
M5R1 is trans model number NOT what it fits, like Ranger is Ford Model but doesn't tell you engine size or 2WD or 4x4, just a Model designation
1997 was the last year of the speedometer cable hook up on tail shift housing which you need on 1994 Ranger
You will need the clutch/brake pedal assemble for 1994
The clutch master and clutch set(pressure plate, disc and slave)
2.3l Flywheel
And manual trans drive shaft for your Ranger model, i.e. regular cab, extended cab or long bed, they are all different lengths
Manual trans floor plate and boot
optional is a manual trans steering column to get rid of current automatic shifter