During your waking hours, nothing feels amiss at all. Keep in mind too that the dosing is once a week. It took a week or two for the effects to start for me, and they persisted for almost a month after I was home. Unlike reports from the various psychedelics you listed, I felt absolutely no euphoria or “spiritual awakening” from any of it; I just woke up every morning and thought “wow, that was fucked up!”
It'd be interesting to compare to the dreams of people who take the drug without travelling, e.g. medical staff native to malarial regions, who take it as a prophylactic when interacting with malaria-infected patients.
I can only speak to my own experiences, but while I have observed the phenomenon you describe in preparation for travel/while travelling, Chloroquine dreams were waaaaay more dramatic than anything I've experienced with other travel. I forget what the exact timeline was, but I think I started taking them about a month before departing, and the dreams started about two weeks before departing, and stayed pretty much constant until a few weeks after I'd been home and stopped taking the pills.
The area I was visiting was not so different from other places I had visited or worked, just with a greater chance of maleria and lower chance of getting quick treatment.
It is nothing like a psychedelic trip for me.
If you want to try and see if you get weird/strong dreams there are a lot of anecdotes around the supplement ZMA. It is just anecdotes but I've seen threads started on many different training forums from newbies asking about it.
As you see, not too much data but it is still something. From the reports, it doesn't look like there is recreative potential. It doesn't hurt to look but the general idea is that if a strong psychoactive is not heavily controlled/illegal, the effects are usually nothing but unpleasant.
However.. Some of the alternative drugs have very serious warnings that if you have any history of mental illness you probably shouldn't take them. Mefloquine is particularly prone to this I think and the symptoms sound like what the OP described (insomnia, vivid dreams, etc). You shouldn't have that with doxycycline, but it can make you photosensitive which isn't ideal in Africa.
Now I'm intrigued. What do anti-malarials do to healthy people? Does anyone take them recreationally to experience this effect, the way they do other "weird downers" like mescaline/DMT/salvinorin/etc? Or is the psychotropic effect of the drug predicated on actually having malaria?