Obviously, since this is ancient history after all, the surviving source base isn't as good as we'd like, but for the experience of the 5th century invasions we do have some good sources that give us what we could call grass-roots views of the 5th century invasions that toppled the Western Roman Empire. One of such sources are the letters and poems of Sidonius Appolinaris, a Gallo-Roman minor nobleman living in Aquitaine (south Western Gaul), who tells us plenty about the Visigothic takeover of the region in the mid-5th century and how he was forced to cosy up to them, playing backgammon with King Euric and the like. From the Alpine lands, there's the life of St Severinus of Noricum (modern-day South-Eastern Bavaria and Austria) by Eugippius (a monk who was a near-contemporary and personally knew the man to whom he was biographer), which provides a good account of how bishops stepped in to fill the void left by the collapse of Roman provincial administration, providing aid and hospitality to those left displaced or impoverished by the invasions and diplomatically negotiating with barbarian warlords. For an African view of the Fall of the Western Roman Empire, we have Victor of Vita, who wrote a history of the first two Vandal rulers of Carthage, which mainly focuses on how the Vandals (who were Arian heretics) persecuted the orthodox natives.

I'd also recommend having a look in the bibliographies of the main up to date surveys of the fall of the Western Roman Empire, such as Peter Heather's "the Fall of the Western Roman Empire" or Guy Halsall's "Barbarian migrations and the Roman West", to get an even better sense of what kind of sources are available for historians of the 5th century West to use.