Ċirkewwa gets recommended as a blanket "great diving in Malta" answer, but the four main sites near the point suit fairly different experience levels. Worth checking which one a listing actually visits before booking.
The four, roughly compared
P29 patrol boat — Sits upright around 22–36 metres, intact enough to swim through the wheelhouse. Suits divers comfortable at depth with some current; not a first-dive-of-the-trip site.
Um El Faroud — A former oil tanker split into two sections, deeper and larger than P29, starting around 18 metres and dropping past 30. The scale is the draw; visibility is usually good but currents can pick up around the bow section.
Rożi tugboat — Shallower and more sheltered, generally the easiest of the four. A reasonable choice for divers who are certified but not yet comfortable with strong current or deep profiles.
Cirkewwa Arch and reef — Not a wreck at all, but a shore-entry reef dive with swim-throughs, good for a lighter second dive in a day or for less experienced groups.
What to ask before booking
A "Ċirkewwa wreck dive" listing might mean any one of the above, or a two-tank combination. It's worth messaging the operator to confirm which site (or sites) are planned for the day you're booking, particularly if you're diving on a specific certification level or want to avoid deeper profiles.
Conditions matter more than the site
All four sites can be affected by wind direction — a north-westerly makes the point choppier and reduces visibility across all of them. Operators will usually reschedule rather than run a dive in poor conditions, which is worth knowing if you're booking on a tight itinerary.