FFXI is fun.

You just need to play the popular jobs (non-melee) and you'll not LFG for 10 hours. Preferably, you should play Bard, Red Mage, Blackmage, Paladin or Ninja if you want to minimize your time on lfg.
As for roleplay, this game is the best. Missions and storylines are WAYYYYYYYYYYY better than WoW or any other MMOs. There's only one problem, you can never solo these missions. You'll need a whole team of balanced players (i.e. whitemage, red / brd, blm, paladin / nin, and 2 extra players).
I've completed Promathia, Zilart and my nation Mission and I can assure you that it's worth the time if you are looking forward to the storyline. As for soloability, there's almost none.
If you feel like being uber and look really good and stuff, prepare to invest another 1 year or so to get the "God" armors or your Dynamis AF armor. As for the "God" weapons, it's unlikely that you'll be able to get it since it'll cost you roughly about 100-150 million gils.
Also, making money in this game is a major pain in the butt at lower levels (70 and below). Unless you are lucky to get into HNM(Hyper Notorious Monster) Linkshell, there's almost no way to make 1 million gil a day. Best I can make is about 100k/hr with my fishing skill at lvl 100.
If you are going to craft to make money, be prepared to spend more than you can make. Crafting besides fishing at FFXI is a money loss unless you make a High Quality item. Sometimes, the items to craft can also be broken thus rendering you having 100% loss. This applies to crafters who are looking forward to make armors like Scorpion Harness(bonecraft) or Haubergeon(smithing with goldsmith sub). You'll roughly lose 1.5mil gil (depending on your server) for losing such items.
When it comes to how "uber" your stuffs is, be prepared to face gil buying competitors (especially the Americans). Most of the time, you'll lose to them because they buy their gil at such cheap price.
Oh, also, if you are serious about partying, you might want to group up with Japanese for exping. Though it's going to be *really* hard for you because Japanese party with Japanese onry

(you can get lucky sometimes) Americans, well.. 80% of them are idiots 10% AFK every 10 minutes 5% leave you without notice 5% are good players.
Unless you are prepared to spend 3 years of your time (like me) doing nothing but play FFXI, there's going to be very little chance of you doing anything much in FFXI legitemately. Of course, you can always buy gil at
http://www.ige.com and twink your way up to 75 in less than 3 months.