Select your target.
You mention economy sheathing/decking. Consider Advantech at 84 lumber. Aprox. $30.00 per 3/4" X 4' X 8' . About half the cost of similar quality plywood.
You mention load bearing, Consider Advantech w/ crossmenbers on 24" centers.
You mention cantilever/overhang. I run Advantech 6+" at times.
Fine thread screws are for metal studs.
Course thread screws are for wood products.
Consider prepositioning the decking. Trace cross members underneath. Invert decking, predrill clearance holes for your deck screws between drawn lines x 12".
Reposition decking to reference marks, clamp in place and drill 3/32" pilot holes in frame.
Drywall screws are for drywall. #8 construction screws are for construction screwing.
HD has them in T-25 drive. 1 1/4" or 1 5/8". You will never snap off a proper fastener.
Check out the complete line of construction screws.
I can not think of any application for a nail in layout construction.