I love openscad and almost everything I've shared on thingiverse was done in it. It's also essential if you want to do customizable things on thingiverse so well worth learning.
Fusion360 is also great - but won't run on some of my computers since they're too old and is a fairly steep learning curve. I've been trying to learn it the past few weeks and keep thinking it clicked...but then getting stuck on what should be simple things
My biggest beef is that almost all the documentation is videos and I hate video documentation - I like to learn at my speed not wait for the video to catch up. And I can't always listen to videos so again written documentation is much nicer for me.
Windows 10 comes with a free 3D Builder app that's actually not horrible. It's not as powerful as Fusion but for a lot of things it's actually pretty great.
MeshMixer is also good to have on hand - it's a different approach to cad being focused on meshes but since STL's are meshes it's great for quickly editing and fixing STL's. Though it can also be kind of tricky to come to terms with.
Really almost any CAD can be used - if you can't export as STL then you can probably export as something that can be opened by something else that can export as STL and that's really the key.