I love this thread and spent many hours reading through it (not even finished but it's late haha).
I have been doing this ever since I was into aquariums (25 years at least, on and off), and always threw the pothos type plants in there.
Except I would always cut pieces at an angle off my parents house plants.
They would always grow massive roots and grow very long.
It seems they do not require much lighting at all, sometimes it would grow behind the tank in the darkness and would always be plump and a healthy green, always.
Now that I'm back into the hobby, and have a 120 gallon in my bedroom, i have added some succulents to my closed off overflow. After a week a few are showing roots (they were cut under the 2nd node at an angle), even one that dislodged and floating has grown a root, i may leave it alone to see if it'll turn into a floating succulent.
Here you can see the succulents on the overflow, i used twisty ties to secure them. Ignore the floating aquarium plants, they're now planted
mother plants variety of succulents
I do want to try a variety of other types of plants other than pothos and succulents.
Will update when it happens