Twenty minutes ago. Here's a list of actual uses that I have personally done in the last week.
I have large (64 core, 256 gigs of ram) servers in a university data center, and a lab full of small atom machines.
I can run matlab without a gui, but still have graphs etc pop open when I need one.
Yesterday I ran a remote Firefox on a machine in the same room so that I could play sound on attached speakers, but still view the video locally, on my laptop.
Sometimes I need to run expensive applications on a big machine, but from the comfort of my home or office. X11 forwarding is pretty nice for that.
I run headless Linux VMs on my mac, and ssh to them, running them natively displayed on my laptop. Sure, I could use whatever VMware gives me to display apps, but X11 works better.
It's got plenty of valid use cases, and that's just ones for me.