The Condor was good against single ships or some convoys as long as there was no opposition, but after in introduction of CAM-fighters and the early escort carriers their luck had run its course.
The B-17 was a high-altitude strategic bomber not equipped for low-level attack. It was replaced in the Pacific with the longer range, higher bomb load B-24, mainly because of the wish to keep all Fortresses in North-Europe where they had a slightly better record of survival that the Liberator.
At Midway the B-26 Marauders - medium-altitude bombers - also fitted with torpedoes - did not do much better also incurring losses.
At that stage USAAF was still in a steep learning curve - but learnt quickly.
Later in the war Beaufighter's, Mosquitoes and Mitchell's did much better because they were more manoeuvrable, better armed and better trained for the job.