I'm in Yorba Linda, so I called Adelphia as well. I have DirecTV and TiVos right now, and after reading the User Guide for the DVR, I was very disappointed in it's feature set. Realize that I could sell 2 DTiVos and 3 additional receivers by changing to cable (and probably save monthly as well since I already get internet through Adelphia).
These are must-have items in a DVR for me:
#1: 30-second skip. Even if I have to turn it on via a hidden key sequence, I cannot live without this. Football's way too nice with this feature. Also, it makes very short work of commercials. I refused to buy a TiVo until they added this feature.
#2: Season Pass or Double Red Dot. I need the ability to record all episodes of a show, presumably even if it changes nights or times, but I would settle for ReplayTV-like features where it looks ahead or behind by a single timeslot and gives you days to check on. There's no functionality for this. Instead, it blindly records the timeslot regardless of what's in it.
#3: Wishlists or Themes. I need the ability to find shows based on keyword searches. This is invaluable for sports.
#4: Dual Tuners. Watching weekly episodic shows and sports such hockey or football can be problematic with a single tuner. Since I got dual tuners, I never have this problem anymore.
#5: Sort by Priority. Another TiVo feature that I've fallen in love with is the ability to sort Season Passes and Wishlists into a long priority list. This allows me to set the importance of shows for the dual tuners to record. Between dual tuners and Priority Sorting, 99.9% of my recording can be automated on a single box, with zero intervention. I don't have time to set up recordings all the time.
Unfortunately for me, I would gladly pay up to $500 for these features as opposed to a DVR that is hardly better than a glorified digital VCR, so Adelphia really has no options for me.

Instead, I am going to get HDTV through D* now and see how much the HDTiVo price comes down by September when all the new seasons begin (sports and TV). Hopefully the TiVos come down by then.
Also, I am going to see how many channels I even get, since I am pretty much up against the hill and currently get NO signals from radio, TV, etc. from LA. So, I probably won't get any local channels OTA.
Still since I love sports, HDNet (for hockey) and ESPN-HD are the two most important channels to me, followed by CBS and FOX for football (all available on D*). I really don't watch anything on ABC or NBC except Leno (which is a waste of HD IMO--he just stands there). And I am still waiting for KTLA to go HD for Smallville and for ANYONE to carry FSW's allegedly HD broadcast.
Unless they come out with a working CableCard TiVo or ReplayTV, I just can't see getting cable again. These underpowered cable box DVRs just won't satisfy me.