It depends on where your group falls on the bell curve of players. If you fall into a middle range I assure you, they can be excellent.
Put it this way. I’ve seen plenty of great published campaigns, Curse of Strahd, Tomb of Annihilation, Kingmaker Revised, Enemy Within, Age of Worms, Curse of the Crimson Throne, Rise of the Runelords etc.
I’ve never seen a single great homebrew adventure. Not one. Ever. You might say it’s Great but at the end of the day, no one but you and your players will ever know for sure, right?