Super Unleaded Gas in an 07 Toyota Camry SE?

Recently my friend and I were driving around and needed to fill up on gas. I was curious as to what Super Unleaded would do for my car and she said not to use it. She claimed that Super Unleaded is only for bigger trucks and will ruin my engine. Needless to say, I'm a little confused as I've heard that even though most cars can go on Unleaded, Super is just the Rolls Royce, if you will, of gasoline. I've heard it's better for your car but not mandatory to use in most cases and that using it wouldn't be detrimental. I have two different opinions and am curious to which one is correct...