Since BXLio is a self-described not a big coffee guy I'm gonna take a swing -
All coffee methods have their merits -
Personally I have 9 brew methods at my house because I am a big coffee guy. In my humblest of opinions drip (standard) is shit. You are using a great deal of coffee beans brewed fairly inefficiently and then some of it needs to sit - which sadly makes it worse by the minute (having nothing to do with heat and everything to do with air.)
I also can't stand K-cups - we have them at my job. Super environmentally terrible, and poor quality beans. For these reasons I have pretty much pushed for it's replacement with something almost as easy and infinitely better ... (details to come) - that being said people on the go-go still enjoy it's ease and quickness - but will we all like living in K-cup igloos after the apocalypse?
I have enjoyed french press coffee many times, and have a big one at home. I occasionally use this to make coffee when I have a few guests over. Not a bad method - but the actual pressing can lead to some grit and some bitterness that is not intended so i prefer the Sowden Softbrew - also what I have brought to work to replace the K-Cup. Plus it makes great cold brew overnight in your fridge!
Although the Sowden is an incredibly low acid high flavor brew - the tastiest brew method for me is the Chemex and that is my go-to for multiple guests coming over since I don't have a solo or two cup one, only the big 8 cup version. It does require a filter which neither of the previous methods require.
Other interesting methods are the pour-over styles, namely the hario and kaleda (I prefer kaleda)
Lastly you mention Aero-press!
I love me some aeropress - when I have time, and just want one cup for myself i often reach for the aeropress - the coffee ritual for me, weighing and grinding the beans, measuring out my portion, brewing etc. is made even more fun with a little assembly of the aero-press - but again I say when I have time because if you do not clean your aero-press before enjoying your cup it can be a real pain to get apart and clean. My favorite travel piece (light) great for camping and at one point you could even use one while flying in an airplane - damn terrorists ruin everything.
So to answer your question
Best low-skill ease of coffee-making - Sowden Softbrew
Best replacement for French press - Chemex
Great single cup options - Kaleda or hario-style pourover
Delicious but requires more skill and time - Aero-press.
Obviously all this should be done with beans ground to the correct format and that have bean sealed in an airtight container. These beans should be no older than a month past roasting date.
Thoughts?