There a clients that add expiration dates to events. I want to offer that for ours, as well, as it's cleaner than deletion, since relays don't have to store the deletion-request events forever.
Not just useful for normal notes; also stuff like reactions or zap events, could eventually expire.
Sort of ties into what Will was saying about abstracting out stats, so that you can delete the corresponding events without loss of information.