https://www.emacswiki.org/emacs/ShowWhitespaceMode <-- is this the ideal way to resolve "make all trailing whitespace visible"

You can just use whitespace-mode for this. That + a hook to delete trailing whitespace on save is quite nice

auto delete scares me a bit due to bad intedraction with outline heading collapse mode

I personally do this + add highlighting of content after 80 cols