This page explains use cases and examples of SSH tunnels while visually presenting the traffic flows.

(Note that you need to scroll down a little to see the actual SSH command examples).
Source: Visual guide to SSH tunnels