Sounds like you need to think about your battle plan a little bit.
Building a 900-1,000 horsepower race engine isn't easy, even with a well stocked bank account.
You want to build a drag racer with a manual transmission?
All my cars are sticks even the cars that are more drag cars than street cars, however I rarely get them to the track.
You mention wanting a stick because it's fun, but losing to a 350 Horsepower Camaro in the first round because it isn't very consistent isn't much fun either.
There is soo much more than just 1,000 horsepower and 4-speed transmissions that make up a vehicle.
A diesel transmission may be able to handle the power under normal driving conditions, but to withstand maximum power slam shifting that drag racing requires it is still going to need some serious beefing up.
A well built engine is SERIOUS money, I don't care how you slice it.
If it's a drag only vehicle start with a big block. It isn't uncommon to get 550 cubic inches out of them nowdays.
Since you mentioned aftermarket blocks, they can be purchased all the way up to support a 960 cubic inche engine!!
Once you spend the cash building a 1,000 horsepower race engine you will need to run serious fuel to feed it.
This is totally ignoring the fact that you will need a hell of a chassis to handle that kind of power reliably and be at all useful.
Good thing this is just a dream.