Out-gridview is primarily used when you want to view a list of objects with a selected group of attributes included in a way that is more graphical, easier to manipulate, and allows you to modify your query without having to re-write your powershell code.
Out-Gridview will not work well for the first two situations you note, as the data cannot be easily exported to either of those using Out-Gridview. You would use export-csv and import the data to Excel if you wanted it that way, and if you wanted it in a website
view, you would need to export the data with headers and formatted for HTML. Out-Gridview does neither. It would be useful for your last situation, though.
