INFO:
I play Little Martha (Duane Allman/Dicky Betts on Acoustic/Dobro respectively) in E; it's one of the prettiest little songs ever written, and you can hear it on Eat A Peach. I learned it from an old Allman Brothers songbook I had back in the day. It may have been done originally in Open D (like open E, but all strings one step down so less tension on neck/strings/fingers). You can find tab on Chordie - haven't checked it for accuracy.
Bob Dylan recorded the entire Blood on the Tracks album in open E.
Joni Mitchell. She plays in 50 (!) different tunings, including Open E. Some dear person (God Bless him) posted a whole bunch of her tunings with the associated songs; you can get the posting at "Mitchell, Joni - Tunings" on this site. Bet you can find something you like.
ADVICE:
I encourage you to get a spare guitar and leave it tuned to Open E, and OUT of the case. If it's lying around (or in the stand), you'll be likely to pick it up every time you walk by and noodle around a bit. Before you know it, you'll have developed some tunes of your own! Probably will start as a few different riffs at first, that you'll string together late one night while normal people are asleep.
Right now, Musician's Friend has a Rogue acoustic for $79 and a Rogue acoustic/electric for $129; both are highly rated, and not just for something so cheap - they are apparently just plain decent, period. Put D'Addario EXP-26 strings on. These are, IMHO, the finest strings on the planet. Acoustic Phosphor Bronze, custom light - top 3 strings a little lighter for better bendability, with coating that makes them last 3-4 times longer, which I can vouch for - worth the few extra bucks. I just ordered a bunch of sets from the "Clearance" tab at Musician's Friend; they were $10/set.
And get a slide; I use thinwall Chrome or Stainless metal slides, although many fine people (including Duane and Bonnie) use glass. Don't wait on taking up slide...I wish I had done it years ago. Frustrating at first, but you know what happens when normal people are asleep...
Hope this helps!
Get your slide and let's get it on!