Re: How do you mess that one up?
Yes I agree, it is definitely a warning sign. If there is no way round the SQL Code to do what you want without using TOP 1, then you need to have a look at the schema and maybe redesign.
But I guess they say write first, optimize later if needed, which is probably what happened here.