No it doesnt have to be from a base model tranny. You can use any of hondas H or F series tranny, it will bolt up fine.

As for custom midshaft, I dont think I know anyone that makes them. But you should be fine at any shop that builds motors they are the ones that did mine for me.