Gear is the easy part. If you want to do Super 8 -- as has been mentioned, S8 film and processing are still available and S8 gives a much larger image than 8/8 -- buy and study Lenny Lipton's The Super 8 Book. AFAIK it is the only reasonably complete guide to S8 cameras and projectors. One caveat, it was published in 1975, so says nothing about the last most wonderful S8 equipment.
Don't be seduced by Beaulieu cameras as I was. They're beautiful artifacts and are very capable but they're fragile and maintenance is very expensive. I haven't tried as many S8 cameras as Lipton did, so can't comment on many. Of the few I've used, nothing has shot better than the Canon 310XL within its limitations (18 fps, guess focus, 8.5-25.5 mm). My Beaulieus, with their high ratio Schneider zooms, don't come close. But they and other reasonably capable cameras can do things that are impossible with the 310XL.
Telling a story with film is the hard part. The Super 8 Book isn't much help with that. The most useful book for the absolute beginner I used to be that I've come across is David Cheshire's The Book of Movie Photography. Not quite as strong as Lipton on gear but very good, at least for me, on the logic of assembling shots into scenes and scenes into a larger story.
I once showed a 66 minute epic on collecting fish in Costa Rica to an ichthyology class at the University of Western Ontario. Afterwards one of the students told me he'd just taken a course on film and complimented me on my editing. All thanks to Cheshire, his book taught me how to edit.