Omkareshwar Dam stands upstream from the pilgrimage town, a practical contrast to the old ghats and temples. It is not a romantic monument, but it changes the river and the wider valley, so it belongs in the story of the place.
Visit only if you have extra time or a specific interest in the Narmada projects. For most travellers it is a secondary stop after the island, ghats, and temples.