Perhaps by the standards of the Emirates this is a gorgeous place, but it's stupid a few bridges and a river. The flowers are growing a little, there are many cafes where it is very hot to sit.
The original cool Arabic souvenir market. And a good location for an evening photo of the sail.
If you live somewhere nearby, then you can go, but there is no point in going there specifically.