Currently the same message is displayed on deleting a record with or without cascading delete.
It would be nice to improve this message by additionally saying something like “and all records that make use of this record”. This makes it clearer for a user that also connected records may be deleted.
Being able to add a custom message could also be useful.
Unfortunately, this idea has not received enough votes. Because we want to keep the focus on ideas that are in high demand in our Community, we are closing this idea.