I think a compromise would be to delete notes that receive no interaction or have a 30 day delete timer that resets every time the note receives interaction. I'm not a node operator but I'd bet 90% of their data is notes no one ever sees again.  

 This sounds reasonable, but the 30 days are a bit harsh. (at least to start with)