Beautiful car and would love to hear that if you have any online videos! As a huge fan of Italian engines, a Maserati/Ferrari V8 is just what the car needs! But before you commit to a 6 speed, check out what I've learned about these transmissions.
I have a 00 986S with a bad 6 speed and after lots of research, I've found that the 6 speeds have problems with two things:
1) 2nd Gear - Many Getrag 6 speeds suffer from 2nd gear problems which are twofold and obviously related. First, they will pop out of gear due to a flawed detent. There are aftermarket detents with different designs as well as one company that makes a different internal detent fork to solve this problem but the online info about their effectiveness isn't exactly clear. Of course, the detent problem tends to cause grinding of 2nd gear and damage to synchros and cones which eventually ruins them and will need replacement at about $900 for the cluster. Again, there are aftermarket products of strengthened materials but not much detail on whether they solve the problem or not. All this can be replaced by someone with patience and money; you can do it yourself with lots of the former and a fair amount of the latter. Youtube videos exist of a couple people who have done this and it looks doable although I have not done it myself.
2) Pinion Bearing failure - The 6 speed uses sealed bearings just like everyone's favorite Boxster engine feature and they aren't much good in the tranny either. And in order to replace the pinion bearing, the entire gear cluster on the output shaft must be removed. This is a lot of work but the main problem arises when removing the bearing. Apparently the shaft is hollow on the 6 speed and as a result, it requires an internal tool for support when using a press to remove and install the bearing. One person online has used an old shock hardened steel shaft to good results for this tool and another has posted online the exact specs needed in order to make this tool. But another problem is that a standard hydraulic press is not strong enough and a special press must be used which apparently is very difficult to find. The actual specs for the press are online somewhere but I can't remember them exactly. Then you have to find someone willing to do this and who knows how to do it.
Oh, and if that doesn't scare you off, Porsche specifies that the hollow shaft can only be reused twice and after that, you must replace the shaft which if you have to ask the price, you can't afford it! So, how long should a pinion bearing last? Some people do get many miles but one Porsche transmission expert told me the pinion bearings are only good for 60,000 miles. I suspect that's worst case scenario but for the kind of power you're using, it's a serious concern.
Then there's the cost to buy a used 6 speed, which generally runs from $2000-3500 and definitely more towards the high side. And you never know the quality and condition of the internals, compared to around $500-1500 for a 5 speed.
The pinion bearing can be checked for failure by draining the oil and reaching into the transmission with one finger towards the internal magnet to check for the grey grease and metal shavings from the bearing.
Here's some YouTube about all of this:
https://youtu.be/i6m4b7D5HEE?si=CRt-zN4dNFD1huUO
https://youtu.be/1cdbNDdnp_M?si=hMMYjHl0QkcB9kxG
https://youtu.be/AveToZsaBeM?si=rWrhdSuhE0bZgfDu
And here's one of the better step by step instructionals I've ever found with much info:
https://rennlist.com/forums/attachments/996-forum/1100690d1477169951-996-transmission-rebuild-and-pinion-bearing-replacement-diy-996-g.96-transmission-rebuild-guide.pdf