[dmdsoftware]

It does show in google drive, but I still can't get to a list view, just a bunch of large thumbnails sorted by file date.

Your upload probably didn't finish successfully. Once a video upload finishes, it sits as a black square for awhile with a "processing" note, then you get a 360p video fairly quickly, followed by 720p awhile later.

It's been 6+ hours now I've given up on it.

There is an option in photos.google.com to actually have it add a folder to your Google Drive. Shows up as "Google Photos" in the My Drive root. In this form, it is not unlike any other folder (including list view, sorted in the typical traditional fashion).