700r4 will bolt up and is a mechanical 4speed/od transmission.
you will need to work out your linkages and a way to mount the TV cable to the carb. TV cable is essential, without it (or installed incorrectly) will result in bad shifting or (worse case) destroy the transmission. 700r4 is probably the easiest and least expensive option (assuming you 74 is an auto already). 700t4 will also have a mechanical speedo drive. Thats a plus for your car.
4l60e is just (essentially) an electronic 700r4 and will also bolt up. You still would need to work out linkages and have to add a standalone controller. Some sensors (like a tps) are also needed.
big bonus of the 4l60e (or any electronically controlled trans) is you have total control over when and how it shifts and it opens up the possibilities of things like paddle shift, etc.
Standard opens a whole other kettle O’ fish. Get something out of a sbc so the bellhousing/flywheel/pressure plate/etc all match. Then you need to hang the third pedal and assorted cables and switches.
Driveshaft is likely to need altering no matter which way you go.
I’m up annapolis valley way. You?