When do I use views_get_view_result()? I have basic listing in a View. I can give styles, or unformatted text, provide a link, etc. However, I would need the listing to be a list of linked items, with the destination URL changing depending on context: language, type of user, etc. So I just retrieve the listing with a view, and in the template, I use views_get_view_result to print the fields I need and warp them with the necessary parameters (the dynamic URL, etc.). Is that a good approach or could this be achieve through the config of the View or with aid of another module (Context, Context Views, whatever...). Thanks!
Trying to give a reply to the question title:

you use views_get_view_result() when you need the result of a view inside your custom code. It works fine inside module or theme files.

For instance: you need  to get a list of users inside your custom module. Instead of querying the database with db_query, yuo can build a 
Users View named a_list_of_users and get results with

    $res = views_get_view_result($name = "a_list_of_users", $display_id = "default");


Any additional parameters will be passed as arguments.

I love this function!