An example of a real world effect is one of the largest fibre ISPs in the U.K. They are the only provider afaik to assign users internal IPs, which is then NAT'd. This then gets NAT'd on the router again - double NAT, woohoo! :) I know they desperately tried to get enough public space for all their customers, but were unable to buy a large enough space for it, so were forced into this position.
Interestingly, the U.K. has at least two /8 ranges that aren't even advertised on the public internet, owned by MoD (25/8) and Department of Work & Pensions (51/8). That's 32 million addresses unused as far as anyone can tell from the outside.