The lighting tool designed specifically for hard light using GOBOs is the ellipsoidal reflector spotlight (also called a Leko for a common brand and JoLeko when an HMI is modified to be used as the source).

Ellipsoidals are commonly used in theaters for plays and concerts because they are focusable, accept gels in addition to gobos, and can be hard cut at the fixture.

The downside is they tend towards the industrial…big, heavy, hot, and not always wired for ordinary household plugs.

There are LED ellipsoidals, however. Mostly it depends on how much light you need, how often you need it, and how critical CRI is required.

Monoprice has a small 3200k zoomable ellipsoidal that I find suitable for small spaces. I mount it on a lollipop using some 1/2” hardware.

I print gobos on my phone inkjet using transparency film for the small gobo holder (the light does not get hot).

The CRI is not great but is suitable for non-color critical work, which is what I do.

[edit] It is worth mentioning chromatic aberration. Unless you throw substantial money around, you will have some simply because projection lenses tend to be simple and because small amounts of fringing cover more area as they are projected.