I am looking to record youtube videos and twitch streams, mainly about Super Mario Odyssey. Are there any recommendations on how to connect a switch to a pc?

You will need a device called a capture card, search for this.

Once its connected, does it show up as an application?

No, it’s a video source that you must capture with software like OBS in order to stream or record the video feed.