It there any way possible to have a widget show up as a menu item on the front-end main navigation?
Not in WordPress by default unless you created a widget-ready custom Page template and then add a Page using this template to the menu.
That sounds interesting. How would I go about doing that? The idea I’m after is to display a widget in the menu to give me the ability to create something that is similar to the navigation on SiteGround