I’ve used Audacity, Cubase AI and Ableton Live 9 and they are all good at straight recording. The differences tend to come with how easy they are to use for bouncing tracks around and the effects you get with them e.g. there was a nice feature in Cubase where you could play a track in a loop and then record your guitar several times until you got the best take.
Audacity is the easiest to pick up and get running with if you aren’t using it all the time but possibly not the most powerful overall. Ableton is possibly the most difficult but once you get to know it it is great.
I can’t comment on the quality of the effects between Ableton and Cubase AI but I prefer them both over the stuff that you can get free for Audacity
But, before rushing out to buy one of the packages you might decide if you want to buy a USB audio interface first as you often get one of these packages bundled in, often with some extra effects such as a better quality reverb or compressor.
enjoy