I used a 12mm tube on a Canon EF 20/2.8 to make this shot:
California poppies
EF 20mm f2.8 lens with 12mm extension tube. EOS-3 camera with Ektachrome film. Settings unrecorded. I was trying to make some extreme close-ups that maintained a little more background detail than typically possible with a macro shot (and shooting slide film at the time, so wasn't able to use a very high ISO). I took a series of shots, in some cases the petals of the flowers were touching the front element of the lens in order to be get them in focus!
I'd suggest you simply use a 10 or 12mm extension tube on your 28/1.8 and see if that gives the results you want. It's not a flat field lens, so you'll likely see some softness in the corners, and some vignetting if using relatively large aperture... But those don't always detract, might even enhance an image in some cases.
About the widest true macro lens you ever see are 35mm. You might look for some vintage, manual focus lenses that are
easily adapted
.
The image below was shot with an old manual focus Tamron SP 90mm f2.5 that I bought for very little money a while back. I have about $60-65 in it all together, and $40-45 of that was getting a chipped EOS Adaptall2 from China.
Bee on orange poppy
Tamron SP 90mm f2.5 macro lens (1:2, vintage, adapted) with 20 or 25mm extension tube, at f11. EOS 7D camera at ISO 400, 1/400 shutter speed. Handheld, available light (no flash). The Tamron 90mm on one of my 7Ds. For size comparison, 4 macro lenses: Canon EF 100mm f2.8 USM, Canon 180mm f3.5L, Canon TS-E 45mm and Tamron SP 90mm f2.5.The same 4 macro lenses set up to shoot.It's a little challenging to take shots with vintage, adapted lenses. Both focus and aperture control are fully manual. At the f11 used for the bee on the flower above, my viewfinder was very dark, manual focus quite tricky, and Focus Confirmation stops working. I threw away a lot of shots that missed focus. Also, apapted lenses don't record correct info in the EXIF metadata. Some can be programmed to show the focal length (or approx.) and max lens aperture (or approx.), but none can show the actual aperture that was used.
I also use TS-E lenses for macro a lot... The 45mm usually... Can't recall using the 24mm for macro. Once again, manual focus... but that's no problem with macro. Full aperture control though!