Vast swathes of our favourite records have somehow been passed over, unfairly dismissed or left to languish unjustly in the critical mid-table, from the little-heard cult gems to the guilty pleasures. Mark Beaumont and Roisin O’Connor pick their favourites