Horses (Equus ferus caballus) are a subspecies of odd toes ungulates native to the continent of Eurasia on planet Earth. Horses are quadrupedal herd dwelling herbivorous (specifically grazing) creatures that usually weigh between 250 and 1000 kilograms and are well adapted to long distance running. Starting around 4,000 BCE, horses were domesticated by humans, first for food, but eventually their primary use was as beasts of burden and in particular as mounts to carry humans about.
Like dogs, horse have been bred by humans into a wide variety of breeds for specialized purposes in different areas. Some are meant for racing, others are meant to carry large loads, and others are intended to carry people (including soldiers). An extensive list of horse breeds can be found here.
More than any other non human animal (except maybe dogs) the horse has been a direct aide to humans at war as a beast of burden, draft animal and as a mount. While they can travel quickly over short distances, most horses which move faster than an infantryman tire if they are forced to march for too long, which can be lethal for them.
At first, they were mainly used to pull chariots: small, lightly built carriages which could carry one or more guys into battle. Usually this would be a driver who had the reigns and either an archer or a guy with a spear. They were fast, but expensive to produce. Two major changes shifted chariots to Cavaliers. First, horse breeding produces larger animals, such that a team of horses and a set of wheels were no longer needed to carry a rider forward. Secondly, the stirrup was brought over to Europe. Priorly, difficulties with riding a horse on its own made chariots the only reliable way to use horses in battle. When the stirrup did reach Europe, the chariot fell out of use in favor of mounted warriors such as knights. A combination of heavy armor, mobility, and devastating charges made knights on horseback dangerous foes, and even after the advent of firearms mounted soldiers were valued for their ability to outflank foes. As a result, cavalry of all types remained a major part of military units worldwide until the end of World War I, and served in a logistical role until ww2. Even today, horses still see some use by modern militaries as they're the only way to bring more than a man can carry through mountainous terrain.
In Traditional Games
Role-playing games set in the typical vaguely-medieval-European setting will invariably have horses (or some other setting-appropriate mount, like giant lizards or camels) available to speed travel and increase load capacity between locations. Certain classes, like knights, may have skills to use their horse in combat for increased speed and attack power. Caring for a horse is extremely complicated, to the point that real-world knights and horse-owning nobles had servants specifically tasked with managing the horse; they need to be fed, groomed, and fitted with equipment like horseshoes, saddles, and reins to operate at peak efficiency, and they are not as adaptable to terrain or as capable of sustaining a heavy pace as a human. Most role-players are more interested in crawling through dungeons than playing "Horse Stable Manager 1500", so the needs and capabilities of horses are usually kept well abstracted.
Greek mythology also includes legends of centaurs, creatures which consist of a man's upper body connected to a horse body at the shoulder (the horse-body's shoulder); naturally, role-playing games include them as monsters or player-character races. The ancient Greeks also believed that in far off lands there was a head horned creature called a unicorn, which coincided with a critter that was described in the old testament. Given the context of what they were talking about these were probably Indian Rhinos or distant storys passed down of ice age woolly rhino, but this did not stop European artists to imagine these creatures as being like Horses with horns based off Narwhal Tusks. Since the classical depiction of unicorn was a huge horse with a long sharp horn coming out of it's forehead which it could use to impale people with, in the middle ages the unicorn was a symbol of masculinity. Times have changed. Or did they...?
The novel Romance of the Three Kingdoms said the historical horse Red Hare was able to travel at least 200 miles in a day (25 MPH with an 8 hour march, 8.33 MPH for a tireless 24 hour march). Even in history it was said to be an exceptional horse. When it shows up in /tg/, it tends to be depicted as being as badass as a horse with (mostly?) horse level intelligence can be.
The Nightmare is a fiendish horse. While the exact details were an original creation of D&D for the sake of a pun, there is ample precedent for fiendish horses as ridden by another monster such as Dullahan and the Four Horsemen.
In Warhammer 40,000
In 40k nobody can be bothered to use a horse, except the Attilan Rough Riders. This is probably because bikes, Jetbikes, or even giant xeno-lizards are better. Despite this, horses are eaten by the forces of the Imperial Guard, which comes across as a little odd (how so? We do breed horses for meat too, and it's an animal that could be use as a pack animal in a pickle, so why would it be weird for the wall of guns to have some around?). Never mind, it probably isn't canonical any more...