I didn't redeem the (very low-value) shares because I didn't want a tiny slice of Oracle or a few dollars; I'd rather have an actual chunk of Sun.
Looks like it became very difficult to get physical certificates beginning in the late 2000s (see right sidebar): https://www.giveashare.com/stockcertificates.shtml
For publicly traded shares, yes. In private equity, we still get to play “who tore the stock certificate.”
This allows transfer by “book entry” rather than mailing the physical documents - much like an electronic bank transfer.
At least in Canada, once you get a physical share, you can then buy shares directly from many companies by writing them a cheque without any commissions. Less important as trades here now average around $10, but that's fairly recent for many.
I still have a share of a Canadian bank that spiked in value by the time I got my certificate sorted out. They still mail me a cheque every 3 months for <$1 in dividends.