Hot coronae in local AGN: Present status and future perspectives