Sometimes if you tell the restaurant and server, they will bring out a cupcake with a candle and sing to you. If you plan far enough ahead, you can order a special cake for an extra fee.
Whether it is worth it is up to you. If you like getting the special attention and possible surprises, then go for it.