1-1/2" is the only socket (larger than 1-1/4") I own at this time in deep SAE and 27mm is the largest deep I own in Metric. I have all sockets up to 38mm (-37mm) and 1-1/2" in standard depth.
The 1-1/2" deep has been used to replace electric water heater elements and for the nut on the bottom of a 2" trailer hitch ball when the threaded shaft was too long for a shallow socket, but I could have used my combo wrench instead in that situation.
CV sockets I have only needed a couple times, and the people I have done the work for have bought them (or rented them) for me to do the work and then kept them or returned them when I was done. In the future for personal vehicles I will just look up the sizes needed for each car or trailer axle I own and buy them in advance so they are ready when needed.
Some cars don't require a deep socket at all, and some need 12pt deeps for axle nuts and I don't want to buy any more than necessary because they aren't cheap and they do take up quite a bit of space in a tool chest.