Is there any policy where the insured gets no money at the time of maturity?

Yes, there are two policies on which you will not get any money on Maturity. These are Term Insurance by Annual Premium and Term Insurance by Single Premium.