Was flipping through the old photo albums and came across these pages from 1994, when we had the opportunity to ride in the front of the monorail!
Sadly, it appears that this isn't an option anymore, though. Per this post at wdwpreschool:
After July 5, 2009, this practice came to an end when the pink and purple monorails collided, resulting in the death of a monorail pilot.
2009 was a bit before my resurgence of interest in Disney (i.e., having kids) and so I hadn't heard about the monorail incident.