I think you should spend some time watching YouTube videos on how to use both a French Press and an Aeropress.
Since you've used a simple drip brewer, you need to understand that the French Press and the Aeropress take more time, effort, and practice to get the coffee the way you want it. The French press requires a bit more clean-up to get the grounds out of it. And, you'll need to buy special filters if you use the Aeropress. So, do some exploring and decide which method is right for you.
There are other methods for making coffee. Is there a particular reason why you chose these two?
Do you have a local roaster where you live? It's best to buy your coffee locally, but if you need to order it from the Internet we can offer some suggestions.
When you say you like your coffee sweet, do you mean that you like to add lots of sugar to your coffee?
Rose