Anything is possible w/enough time & money. 😁 Regarding the reliability/dependability of of tuning a Gen X Accord to make high HP/TQ I think the best to answer those questions would be Hondata and/or KTuner. I'm sure during their upgrades/testing/tuning they would have noticed or been aware of weak/vulnerable spots. As @jninja mentioned I'm sure those weak/vulnerable spots will/would be addressed by the aftermarket.
I know you said you didn't want a used MT Accord. However if you goal is to build a high HP/TQ car you are going to be going thru the motor/drivetrain to build it anyway. With that said you are going to end up with new internals and probably spend less time/money than converting an AT to MT.
I know you said you didn't want a used MT Accord. However if you goal is to build a high HP/TQ car you are going to be going thru the motor/drivetrain to build it anyway. With that said you are going to end up with new internals and probably spend less time/money than converting an AT to MT.