That was exactly one of the flows I proposed in Future of lightning address · GitHub
I think it is useful and simple indeed, especially for lightning providers who want minimal DNS operational burden.
EDIT: this is covered in the bLIP that Matt created: Define blip-0032, DNSSEC proof querying over onion messages by TheBlueMatt · Pull Request #32 · lightning/blips · GitHub
This is the omlookup path: a domain that has many users would create a single DNS record *.user._bitcoin-payment.domain. containing a blinded path to themselves (which may actually be a 0-hop blinded path directly exposing their node_id). Clients then use that blinded path to request an offer for a specific user via an onion message.