On OS X systems since Tiger (OS X 10.4), and with SATA bus, the maximum drive capacity is at least 8 EB (8 Million Terabytes), so there's no practical limit on drive size on modern Macs.
Looks like there are a number of companies that make and sell 14 TB drives.
https://www.amazon.com/Seagate-Barracuda-Performance-Internal-3-5-Inch/dp/B07H557CHQ/
One common limitation is purely mechanical - - the mounting holes on larger capacity (4 TB or m larger) may not allow a complete installation with 4 screws. I have seen that OWC sells drive sleds for MacPros that provide different screw layouts for those really-big capacity hard drives, but some users simply install with double sided tape, or even duct tape does an OK job of keeping everything tied in. THAT has no effect on the usability of the actual drive, of course.
Perhaps someone else will add some real world info that is less than 6 years old (look at post #24 from 2013!)
Looks like there are a number of companies that make and sell 14 TB drives.
https://www.amazon.com/Seagate-Barracuda-Performance-Internal-3-5-Inch/dp/B07H557CHQ/
One common limitation is purely mechanical - - the mounting holes on larger capacity (4 TB or m larger) may not allow a complete installation with 4 screws. I have seen that OWC sells drive sleds for MacPros that provide different screw layouts for those really-big capacity hard drives, but some users simply install with double sided tape, or even duct tape does an OK job of keeping everything tied in. THAT has no effect on the usability of the actual drive, of course.
Perhaps someone else will add some real world info that is less than 6 years old (look at post #24 from 2013!)
As an Amazon Associate, MacRumors earns a commission from qualifying purchases made through links in this post.