Here’re some good light novel resources for those interested.
Baka-Tsuki is pretty much the best site for finding and reading translated light novels. They have a very large library and this is where you should probably look first to find a light novel. As a note, series like Haruhi and SAO have been removed from here due to licensing, so you won’t find 'em here.
Yen Press. This is where you want to look for licensed things, like Sword Art Online, The Melancholy of Haruhi Suzumiya, and Spice & Wolf among others. These guys are probably your only bet for actual physical English light novels.
Light Novel Database (LNDB for short) is, well, a database containing pretty much any light novel you can imagine, having cover art, number of volumes, and other basic information. That said, it’s very… bare. Unlike VNDB you can’t make a list of light novels read or anything useful like that, so it’s mostly for finding authors, illustrators, issue numbers, and cover art.
This Light Novel is Amazing! A magazine that lists the best (most popular) light novels and characters (of each gender) based on internet polls. It’s quite a popular magazine, and getting into it is a pretty big deal. Fun to look at, and might give you an idea on what to read.
Finding light novels. It’s rather dated, so some of the links don’t work, but it’s quite a handy resource if you’re interested in actually purchasing light novels.
Translation groups (or just people) such as Nanodesu, Krytyk, Imoutolicious (lol), and others I’m probably forgetting. I left some groups out because a lot just host on Baka-Tsuki.
And, even though it should be a no-brainer, if you can’t find a light novel on any of these sites, use Google. You should be able to find out very quickly if the light novel you’re interested in is translated.
As for a personal list of what I’ve read… I dunno, I’ve read too much stuff and don’t remember it all. I was keeping a list but it somehow got deleted. I’ve read a lot of more obscure stuff. I really enjoy light novels because they’re very easy for me to pick up and put down, plus I like reading books ‘n’ stuff.
There are some big turnoffs to reading light novels in English, though. Most notably the fact that translation quality can vary wildly, and there’s an oddly high amount of simple grammar mistakes strewn about many translations. A lot of stories can also be rather unappealing simply due to Japanese-isms that make them very frustrating (annoying character relationships and archetypes, romance never fucking goes anywhere half the time) but that’s just a part of the medium. My last real gripe is that most series aren’t fully translated, so you’ll only be able to read 5 of your 13 precious Sakurasou novels until the others are eventually translated. As a tip, you can learn Japanese in the time it’ll take a series like that to finish translating.
Overall, light novels are hardly for everybody, and they annoy me very often, but there’s also a lot of great, detailed, and well-written stories out there. They, along with visual novels, comprise a lot of my motivation for learning Japanese. Hope this helps out anyone else interested in reading light novels in English.