At London's Royal Academy and Frankfurt's Städel, two forthcoming exhibitions take sparklingly different approaches