I would consider shallow solo diving pretty much the same risk level as a bit deeper solo diving as long as you stay within NDL limits.
Hookah diving would have lots higher risk levels than scuba though especially if going deep and if using a compressor hookah rather than surface scuba tank supply. AND if not being certified and knowledgeable about compressed air diving.
if wanting to use hookah it would be best to have a scuba tank backup with you and make sure you stay within NDL at all times, it would be otherwise pretty unpractical if you need to haul multiple scuba tanks with you to be able to complete decompression if the hookah dies at the end of a hours long dive.
scuba would probably also be healthier because having much better filtered air. the basic hookah setups are pretty miserable looking filtering wise and I would never want to breath hours from one of those ones, especially if it's gasoline powered and there is high risk of getting the exhaust fumes to the air inlet while you dive. the impression I have gotten from the available hookah systems is that they are generally marketed to persons not scuba certified and who believe they could "safely" save some money by using a hookah instead of scuba gear. the hookah stuff seems to be cheap-o Chinese air compressors slightly modified and some sub-par carbon filter added without further safety measures and no backup whatsoever, the intention being that if the compressor stops you will just shoot to the surface like a Polaris missile and risk burst lung / decompression illness.
I considered hookah stuff last year when looked for options for remote diving but the available affordable options looked too much like 'passive cigarette smoking machines' health wise so I will rather haul the scuba tanks to the remote sites
Maybe first getting scuba certified and then decide later if you want to use hookah or go with scuba instead? if the hookah is very good quality it could maybe be used if you have scuba backup with you like suggested. I would use a good sized pony bottle like 40cf or more for shallow diving, the spare air would probably not be enough especially if you get entangled. the hookah hose is additional entanglement hazard and it is great to have a backup scuba with you in case you need to get out of the hose entanglement mess