They exist but definitely more painful to use at a home setup since their formats are more server oriented, like U.2/U.3 or E1S and few others. And for course the prices - you can get 30,60 TB (and even more), but it’s gonna be >$4k.
And versus the normal M2 drives, the larger server grade are more annoying. For example, I got recently a 15.36TB Kioxia Cd6-R in U.3 format, for $1.3k, which is not bad for ssd prices. After getting the right adapters and fitting it inside a minisforum ms-01. It’s working fine, but it immediately reached its “critical” temperature (while doing nothing) so I had to attach a big fan and cool it. All the larger SSDs which are meant for server rooms will expect lots of cooling.
https://www.serversupply.com/SSD/PCI-E4.0/15.36TB/KIOXIA/KCD...