The sad truth is that a cul-de-sac hoop is a massive and instant property value killer. Most, if not all, HOA rules in high priced neighborhoods prohibit them, and many prohibit front driveway hoops too.
Yet another reason to never live in an area with an HOA