If you are already connected to the grid it does not usually make sense to move off grid.

However you can easily have a setup that cover most of you electricity use. You can also install batteries so you are virtually off-grid with the grid just there as a backup for the bad days.

Solar is the main option because it's cheap, very low maintenance and predictable.

Wind and water turbines requires regular maintenance and really depends on your configuration. With solar I can give you an reliable estimate of your annual production and how many time a year you will completely empty your batteries within 5 minutes with only your home address

For wind I need expensive specialized software if you have weathers station close to where you live, if not I need to have sensor on your land to get close to the same result.

In practice for home use you'll never really know in advance how much your wind turbine will produce.

Honestly for 99% of the cases I would recommend solar first before thinking about wind or water turbines.