A transparent proxy is useful, for example, when you have guests or employees connecting to your network, and you need to control their activity.
They connect through the transparent proxy, and you have your transparent proxy server managing some aspect of that activity, for example, filtering out certain sites, asking them for some kind of proxy-auth, etc...