Since I've been having to look at fantasy worlds more closely, I'll discuss some more magics that I've always felt was underused.
1: Cleaning magic. We all know how this works, some dude sees a dirty building and, saying the magic words, all the dust disappears and everything is repaired. But what does it mean to clean dust? Where does it go? How is only the dust removed? If someone used cleaning magic on a person, what happens? It would be a powerful combat magic if it could 'clean' the person of their blood. Redo of Healer does something similar with healing magic. It would also be pretty useful healing magic if it could clean bacteria. And don't get me started on the 'repairing objects' bit.
2: Storage magic. Again, this is used only for its namesake purpose and nothing else. The Fate series has two great examples of this being used offensively, storing weapons and flinging at opponents. The JJBA stands Cream and The Hand are also examples of offensive uses, moving the openings around and eating whatever stands in its way. The openings may also be used as shields, blocking perhaps any attack. Another aspect of storage magic is that living things are usually unable to be stored. Does that include bacteria? Then it could sterilize medical equipment or food and make them safer to use/eat. Foods also can usually be stored indefinitely and never spoil, implying time is frozen. There's no real reason why living things can't be stored. Could this allow for the preservation of organism through time, of sun-kings and intellectuals storing themselves when needed to rule their kingdoms in times of strife? Allowing the storage of living things also opens up the ability of secret moving homes and villages. Tsukimichi played around with this concept. An anime which takes this to the extreme of there being dozens to hundreds of houses, villages, and even cities moving around in other dimensional portals could have an interesting concept.
3: Psychological magic. I've touched on this before, that this magic is practically untouched. For example, ep3 of Tensei Kizoku had 'calming magic'. Imagine the combat potential. Calming an opponent down to the point that they aren't in the mindset to fight. Calming allies to help them think more rationally and deliberately. Imagine the therapeutic uses. Imagine the control this gives, someone selling hits of this magic like a drug. In ep2 of Shijō Saikyō no Daimaō, succubi have great aptitude for magic. So essentially like a human, but better. How original. Perhaps succubi could instead specialize in psychological attacks. Have them fill their opponents with extreme rage, unnecessary caution or recklessness, or crippling depression. Make them unable to fight with volatile emotions. That would be an interesting take on the idea. And they can also increase people's libido, because succubus. I'd rant a bit longer, but it's getting late and I'm too tired.
First, while direct magic (such as "cleaning" people of blood or storing them in storage magic might seem useful, it should definitely be resistible, regardless of what the original was like. Spells not intended as offensive spells can be assumed to be very easily resistible, with them hurting people only as often as industrial or household machinery of the real world. I guess using them in battle is the equivalent of bringing a chainsaw to a shootout.
Second, you're on a manga site. And the thing about manga is, "save-or-die" spells don't look good there. Which is why in visual media, mages rely on projectile spells. Shiny, big, highly visible projectile spells.
Third, the same applies to psychological magic.
Fourth, I've seen examples of pretty much everything you mentioned.
Now for specifics:
1. Cleaning magic is usually seen as a "holy" attribute spell. I even saw a setting where clerics refuse to use it for mundane cleaning, and insist on only using it for purification of evil. Thus, it is not a morally-neutral force you can abuse. But it does clean bacteria and is part of every healer's arsenal. Yes, it can repair objects, because "holy" magic can repair everything, even people.
2. Storage magic where living things can be stored is usually seen as a higher-level version. For example, Man Picked Up by the Gods had to learn "dimensional home" to carry his ooze of slimes with him. Such spells are usually seen at the archmage level, and a village that moves around in one would be the comically overpowered village.
People who want to be preserved for the future have many other options. Such as ascending into a long-lived creature like an angel or a lich. Or getting sealed. Or using reincarnation magic.
Using storage magic for sterilization is the only part that's interesting. Assuming viruses count as living things for the purpose of this magic (in the real world, they're kind of on the border between living and nonliving). But cleaning magic is usually portrayed as easier and in the same school as healing, so healers will probably rely on that.
3. Psychological magic is really just a reflavor of psychic powers normally found in modern and sci-fi settings. There is nothing left to explore here.
Succubi in Shijou Saikou no Daimaou have great aptitude for magic and are also perverts who misuse magic out of their own will. And I like this interpretation more.