Add the ketchup, apple cider vinegar, brown sugar, molasses, yellow mustard, lemon juice, and Worcestershire sauce to a medium saucepan. Whisk everything until smooth and the sugar begins to dissolve.

Stir in the minced garlic, minced onion, smoked paprika, black pepper, chili powder, cayenne pepper, and salt. Pour in the hot sauce to suit your preferred heat, then add the water and mix well.

Set the saucepan over medium heat and bring the sauce to a gentle simmer. Reduce the heat to low and cook uncovered for 12–15 minutes, stirring now and then to prevent sticking. Add a splash of water if the sauce gets too thick.

Taste the sauce and adjust the salt, hot sauce, or sweetness as needed. For a smoother texture, strain it through a fine mesh strainer. Let the sauce cool before transferring it to a clean airtight jar.