It is real but the catch is usually baked into a slightly higher daily rate or they make you take their full insurance package, so you are paying for the peace of mind either way. Still worth not having a blocked sum hanging over your credit card for weeks after the holiday. You can rent a car without deposit in Turkey through places that specifically offer it, check the listings on this site
https://turkey-rentcar.ru/en/no-deposit/ .