DynamoBIM is here to help you. Simply follow the Dynamo Graph below and you will get it done!
This example only shows you how to change the name of the rooms to upper case but you could use this same method to change the text of Sheet Names, Sheet Numbers, Views and most any text parameter to upper case. Simply select those Revit Family Instances and change the parameter name from "Name" to something else. I have tried it on Sheet names and views already!
Try it out on your rooms and on your other Family's text parameters. You will be glad you did. I recommend running the dynamo graph in "manual" run mode. The results are more predicable.