Switching ISPs is a pain in the balls... at least I have a choice now. DSL vs Cable internet... Never had DSL nor have any experience with it. Anyone have any input? I'm hoping the junk equipment they give me can have the routing function disabled or some sort of bridge mode because I'm not giving up my PFsense router...

I believe they use ZyXEL modem/router combos. I have no idea what model they'll send on the 500Mb tier.