I, for one, disagree that it "will never be even remotely an important part of Realm Works".. on the contrary, I think it will be one of the most important parts. Of course, that just goes to show how opinions and perspectives differ.
You're right. It will be THE most important part.
Let me throw you a few examples here:
1) You've decided to play Pathfinder with your friends. Short notice, you plan a night of character building, but everyone's already done...you're not ready... wait! To the LW webstore! LOOK! We be Goblins! is on sale for immediate download for $0.99!!! PERFECT! Buy, Load, print sample characters from HL (already loaded in RW). Play.
2) You're a new GM, who finds it hard to keep track of everything in the damned universe all at once. You and your players decided to play The Mummy's Mask AP. You had no idea what you were in for. You go to the LW Webstore and....The Mummy's Mask AP in RW is available for the low low price of $19.99!!! (or $4.99 per chapter) Well, you have the books, but you KNOW RW makes running a game easier. Let's do it!
3) You're looking to run an online game with your old high school DnD group. You're running online, using Skype and RW (with new improved Player Edition and Webview!!!) you use Roll20 for the combat interface, and RW for the info delivery system. You're not sure how much time you'll all have, or how hard it is getting together, so everyone votes for 4 hour games whenever they can, so no AP's, short games only.... Hey, Pathfinder Society has just the modules for you! Go to LW webstore, decide on PFS Season 5, select an appropriate module for the low, low price of $0.49, and you're off to the races! (or, conversely, a season pass for $9.99).
4) You use RW. You run games. You play by your own rules! You don't need no stinkin' modules! You work and write your butt off for a great database. You share it on the forums for fun (Or, better yet, sell it on the LW community Market, for 25 cents, of which you get 10). Profit for your time!
The ability to buy adventures, worlds, scenarios, etc... in RW is not only a CORE component of what we got going on here, but it's the whole business model. You didn't think that LW would make all their money from $50 sales and $5/mo Sync services did you?
These examples are all just for Pathfinder. Now, imagine adding Shadowrun, WoD, M&M, DnD 4th/5th edition.
Living Greyhawk, Shadowrun Missions, Pathfinder Society, The Camarilla.... These are sources of INFINATE storylines to be loaded into RW. These go beyond the modules/AP's/Campaigns/World Events.
Sell the series' (PFS Scenarios) for $0.50, the Modules for $0.99-$9.99 (depending on the size/length). Sell Adventure Paths and huge storylines (Gehenna from oWoD, RotRL, Temple of Elemental Evil, etc....) for $9.99-$24.99.
I know I'll be in for $200 minimum by the end of the year (I run PFS, RotRL, and SR Missions games, so I'll be using A LOT of RW products).
DO IT!