Hi, I normally fish off the surf, near the palace(open beach) I have seen guys catch some big fish there. Some go out with a canoe to drop a line, while others cast from the surf. My biggest catch there was the size of my palm but there is hope there. Bait is generally squid or shrimp.
Are you looking for a trip on a boat or just shore fishing? Musandam is a decent area from the shore. But if you would prefer some sport fishing then check out a company online called Ocean Active. They have a decent gallery for you to get an idea. My fish didn't make the gallery, but it was over 35kg and beat me up off the coast of Oman.