How to show paragraph bundles of different types in a view of content containing paragraphs?
You need to create a brand new view. Go to /admin/structure/views/add

For Show: select Paragraph Items

Once in the View, add fields, and you should be able to add Paragraphs item: [Name]


  but I want to see the content that has these paragraphs, not just the
  paragraphs


Then you will need to use Views Fields View to embed this view as a field in your other (node) view. 

You will need to add a contextual filter of nid (to this paragraphs view).

Now in our other view (Node view) add views embed view as a field.

I think there is an option (checkbox) to automatically pass the contextual filter of your current node view to the embed view.

If not, simply add nid as a field in your node view, then when you add the view embed view field, use the replacement pattern of the nid as contextual filter.