It has nothing to do with Brahms, it has to do with La Forge's utterly reprehensible behavior in "Galaxy's Child."
My thoughts on the subject can be seen in my TNG Rewatch on Tor.com: "Booby-Trap
" and "Galaxy's Child
There is that. I just like catching up to when we see bits of the future...
That excepted, I'd still prefer to see him end up in charge of something like the Daystrom Institute...