We've stayed at the Super 8 on
Disneyland Drive about four times over the past 7 years (and will be staying there again next month).
The first time we stayed it was fine. The next time we stayed, it was kind of gross, so we stayed somewhere else for our DLR trips over the next couple of years. Then, night we ended up staying there while we were passing through because we couldn't find a room anywhere else...and found that they had remodeled, and it was a lot better than the previous time we'd been there.
We've been there two more times since then (so I guess we've been there 5 times in all). Once was Summer 2010...and it was nothing great, but it was acceptable...
* The last 3 times we've been there, we've found it to be cleaner than some places we've paid 3x as much for, per night; although I'll be honest and say the bottom of the bathroom door looked kind of grungy in January when we were there...
* The people in the office are REALLY nice. They've let us check-in early before. They are NOT so great about handling noise issues with bothersome guests. We've never had a problem personally...but in Summer of 2010 my father-in-law complained due to the people above them making lots of noise, and nothing was done to stop it...
* We don't usually utilize the breakfast (and we can't this time due to gluten restrictions...) but it seems they usually have day-old donuts, milk, and apples/oranges. Maybe they have more than that and I've just never seen it...my husband has brought back donuts a couple of times for the kids. Something to keep in mind: If you're going during peak-season (DL opening at 8am) and are planning to get in line at the security tables early...then you will miss the breakfast at Super 8 because they don't put it out before the time you'd have to leave.
* The pool is really small. We've only taken the kids to play in it three different times, and it was fine. The pool area is clean - it can be noisy in the evenings, but we've never been bothered by it (we're either not there in the evenings, or so tired we could sleep through a nuclear explosion..)...
*We've never had to park off-site, but it *can* get cramped if you're going at an extremely busy time (the last time we were there we had to park in the back...the tink half marathon was happening and the motel was full). There is potential to not have a parking spot, but it has never happened to us (and many other hotels in the area have the same potential of filling up and you having to park somewhere else). There is no additional fee for parking on-site, and that is nice.
*The motel is within walking distance of the trams (about 15 minutes). The added benefit to walking, aside from not having to pay for parking every day at the Mickey and Friends structure ($15 per day!), is that you hold your parking spot...so even if the hotel fills up that day, your parking space is safe.
*You can see the fireworks really good from the motel balcony. It was so nice to be able to watch them in pajamas, and then crawl straight into bed afterwards. We did that on 4th of July in 2010.
*The beds are ok. We sleep alright on them. There is a table with 2 chairs, a dresser under the television, a small fridge, and a microwave. One sink. Not a ton of space for luggage...a rod and a shelf above it, with one of those luggage unfolding things underneath (lol, sorry - can't think of what it's called

)
*I personally spray the bathroom down with Lysol, and use Clorox wipes on doorknobs, faucet handles, tv remote, etc...but I do that at the place that costs $150 a night, too - it's just something I do.
* It's not the best you could do...but it's not the worst, either.
Anyway, hope that helps. We looked into staying at the Alpine last time too, but I read a bunch of reviews that said the beds were bad and the property VERY loud at night, so we just went back to Super 8 (we've had to skimp on the hotel portion of our trips lately..).
OH - I just noticed you're asking about the Comfort Inn...that was the place we paid $150 for (the kids' suite). Super 8 on Disneyland Drive is cleaner...but the bunkbeds/extra room were nice to have.