Short answer: no. It's correct to use qué tal N (and one of a few verbs can possibly go in between) to ask about how something or someone is going (going well, going bad, etc.), but you don't use it to remind someone about something, like you did with the waiter. If you do this latter thing, you will be understood, probably, but it's not common usage and it may come off as sarcastic. Let me explain:
First, the correct usage. The phrase is constructed with qué tal plus an optional verb plus whatever it is that you want to inquire about. The optional verb can be estar, ir, andar and a few others. If there's a verb, it will have to be in the correct tense. For example:
¿Qué tal fueron tus vacaciones?
(or ¿Qué tal estuvieron tus vacaciones?)
means "How were your vacations?" or "How did your vacations go?", but you can also say
¿Qué tal tus vacaciones?
and it will be understood the same, since you mostly ask people about their vacations once they've returned from them, so the past tense is implied.
In the cases where you have a verb, you can mostly substitute cómo for qué tal:
¿Qué tal anda tu trabajo? = ¿Cómo anda tu trabajo?
¿Qué tal está tu esposa? = ¿Cómo está tu esposa?
Now for the wrong usage. You don't normally remind someone of something with ¿Qué tal…?. If your waiter has forgotten about the coffee you asked for, and you say
¿Qué tal mi café?
you will probably be understood and the waiter will probably remember about the coffee, but not in a good way. The sentence sounds as if you had said: "How's my coffee going along? You know, the one I asked for fifteen minutes ago. I'm asking you because I'm sure you're as concerned as I am about its absence." I think (but I'm no English native speaker) that using "How about..." (in English) for this situation would also come off as rude. There's no polite direct way to remind a waiter of an order s/he has apparently forgotten; if you're not sure, you could stick to the absolute minimum and just say
Perdón, ¿mi café?
where perdón is intended simply to call for the waiter's attention and soften the request.