I moved from a narrow generalization to a broader one. You did the opposite - broad to narrow.
Hold on, now we've gone from "there must be more true friend companions" to who fits in the "waifu" category or not? In that case, there are many many harem games with fantasy settings out there where the writing might be more to your liking.
You have a very wrong understanding of what "waifu" means. A waifu is a woman who loves you unconditionally - just for who you are. She can be any type of woman, not just a caricatured loli with boobs the size of a bus. Karlach for example is a classic waifu.
That ain't me brochacho.
Also, you have moved from a broad generalization to a narrow one. "Waifu" in its common meaning and usage and the one that it was specifically created around, is broad. Vastly so. As it is simply "I am attracted to this character" that is it. No conditionals at all besides some level of attraction, be it sexual or romantic.
You have then condensed it down into "Someone who loves you unconditionally" which, is a niche and uncommon meaning of the term. Heck, I cannot find a single prominent usage of the term that actually deals with the character itself having influence on the usage of the term, let alone this specific one regarding "Unconditional love". The closest I can find is when it's being used more like "Wife Material" wherein it is still based on "They have traits I find to be romantically attractive" and has nothing to do with the character itself liking the person using the term.
This lack of character feeling in the term, is very appropriate for its origin. That being anime characters, whom have no interaction with the viewer at all. Even in terms of video game "Waifus" most of the time these don't even have any romantic content with the player character at all, much less the actual player. (For example, popular waifus are the level up characters in From Software titles; Maiden in Black from Demon's Souls, Emerald Herald from Dark Souls 2, the Doll from Bloodborne, Firekeeper from Dark Souls 3 and Melina from Elden Ring. These characters only interact with the player character by offering a few bits of dialogue explaining the lore and asking if they would like to level up. That is it.)
Again, with video game romances, the term more frequently used is "Wife Material" as a result. Tali'zorah vas Normandy from the Mass Effect series is a popular "Wife Material" character as she has traits that people find romantically attractive (Meanwhile Garrus Vakarian is a popular "Husband Material" character from the same series). It is not predicated on these characters being romantically involved with the character (In Mass Effect 2, Garrus wasn't romanceable. But people still called him "Husband Material" due to his overall character) and most definitely not anything to do with "Unconditional love" of which neither character provides (Both characters can and will leave you if you make decisions that upset them greatly, even if you have romanced them fully)
