The Main connects the Rhine and Danube rivers, but there are plenty of sights that make it a destination in its own right