Superia is not looked down upon by anyone who has actually tried it, IME.
There may be those who prefer the specific look of certain emulsions, which happen to be labeled as "pro" films, but those who actually "look down" on it just because it is not labeled "Pro" obviously haven't tried it.
FWIW, I am biased. Superia Press 800 is my go-to film for nearly everything I shoot in 35mm color neg.
BTW, if you buy the film in Press packages, it is a professional film. Almost all of the advantages of a pro film are there. You have a quantity of film from the same emulsion batch that has been stored identically, it has 36 shots per roll, and, presumably, any store that bothers to stock the Press packages will receive the film in a large shipment, having been handled exactly the same way during transport as are the pro films, and they will presumably continue to store the film alongside their pro films in the fridges.
The only big advantage of professional films that Superia Press does not have is availability in multiple formats. However, that you can get Superia 100 and 400 in 120 is great indeed! Of course, you cannot get them at Freestyle anymore...nor Reala. CRAP!
Whether Superia Press is color balanced for immediate use versus non-Press Superia (which is made with the "wrong" color balance in order to allow aging on shelves or in camera to the proper balance), I simply do not know.
Occasionally I will get drug store Superia 400 if it is just too good of a deal to pass up...but remember, it is only 24-shot rolls this way, and the processing cost is identical if you use the 36-shot Press rolls. Make sure you calculate price per shot when comparing prices, and not price per roll.