In terms of how I use guides, it's typically closer to the need that a column grid provides... to ensure vertical or horizontal rhythm throughout a page. Sometimes these guide layouts are not perfectly spaced in what a traditional column grid provides, but it's further from the world of arbitrary guides. I usually start by creating my margin lines and other major snap points on a column grid and go from there. In terms of other Adobe products, I've always personally liked how Photoshop's guides are created compared to Illustrator, since they are easier for me to create pixel perfect guides.
In terms of how I use guides, it's typically closer to the need that a column grid provides... to ensure vertical or horizontal rhythm throughout a page. Sometimes these guide layouts are not perfectly spaced in what a traditional column grid provides, but it's further from the world of arbitrary guides. I usually start by creating my margin lines and other major snap points on a column grid and go from there. In terms of other Adobe products, I've always personally liked how Photoshop's guides are created compared to Illustrator, since they are easier for me to create pixel perfect guides.