It's often used to express excitement, admiration, or amazement.
For example:
* "That party was fabuloso!"
* "You look fabuloso in that dress."
It's also the name of a popular multi-purpose cleaner, which reflects the product's perceived effectiveness.