A Manhattan man died of an apparent overdose after an ambulance failed to show up at his building for more than an hour, forcing frustrated cops to finally rush him to the hospital, to no avail, police and law-enforcement sources said.