Modular construction is an innovative construction technology that has attracted considerable attention for its pronounced advantages in reducing reliance on on-site labor, speeding up construction, enhancing productivity, and ensuring superior quality. To extend the applicability of modular construction to structures in corrosive environments, such as ocean floating structures for exploring renewable energy, a rotary inter-module connection employing corrosion-resistant metal materials was proposed herein. Six full-scale inter-module connection specimens made of grade S30408 austenitic stainless steel, grade S220503 duplex stainless steel, and grade A96061-T6 aluminum alloy were tested under axial tension. The load-displacement relationships of each specimen were recorded to enable a thorough analysis of the strength, stiffness, and ductility of the tested specimens. As compared to the conventional carbon steel counterparts, the stainless steel specimens showed superior load-bearing capacity with improved ductility, while the aluminum alloy specimens experienced brittle fracture at the bolt shank-bottom plate junction with reduced load-bearing capacity. Three typical failure modes were identified in the experimental study, namely, plastification of the connector and lower corner fitting, plastification of the connector and both corner fittings, and fracture of the bolt. The load-strain relationships of each specimen were also discussed to analyze the load transfer mechanism and structural behavior of the connection. In addition, the applicability and accuracy of the simplified calculation methods based on beam bending theory and Navier solution for rectangular thin plates, respectively, were discussed based on the test results.