Film (and other long form video).
Internet seems full of examples of this one -- I certainly watch hours of video a day sometimes from people messing around in their garage with gear that costs not a lot. You might have to play to your strengths (if you have a phone then filming at night gets harder, as do massive zooms, however do it in daylight or with a nice bright light and all good).
Some of them have other skills and maybe some loaner gear from work but plenty do not.
You have plenty of examples of low budget stuff going back decades as well and made on a shoestring with a handful of people.
Games. Fair few people have done some very impressive stuff with unity and unreal engines, and how many games from the pros do that too?
Also while you somewhat dismissed it above this also says nothing of the looks retro but at the time would have been "yeah we might see an arcade machine do that in 10 years" or "yeah you can do it, for one sprite on a plain background with no music and nothing else happening on the whole game" (see a lot of the demoscene) option which any number of people have used to great effect over the years to make things still talked about/known today where so many efforts in said unreal and unity engines are barely remembered even by those that played them.
You can do the old hardware thing if you want but 99% of the time anybody doing that is doing it to teach themselves low level coding, electronics (the line between digital logic and low level coding gets rather blurry, and indeed most of the best coders I see doing this sort of thing come from an electrical engineering background more than straight coding or physics). If you want to do art (be it music, graphics, animations and the like) a la 8 and 16 bit then go for it, many have a great time making such things just like they might have a good time mimicking any other art style. However jumping in with serious/hard restrictions in palette, tile size restrictions, memory restrictions governing object count, maybe animation restrictions and all the rest (which often enough newer systems gained more and more to eliminate or render as small as possible (
http://pineight.com/gba/managing-sprite-vram.txt )
Videos